vigneshkumart50 (5/7/2014)
like this'$ '+REPLACE(CONVERT(VARCHAR(32),cast(round(Total_Amount,2)/12 as MONEY),1), '.00', '') as Monthly_Amount,
why CAST as MONEY and then REPLACE....couldn't you just cast as INT?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day