I am trying to format a number. According the the convert() documentation: http://msdn.microsoft.com/en-us/library/ms187928.aspx
, CONVERT ( data_type [ ( length ) ] , expression [ , style ] ), for type money, style 1 should give me: "Commas every three digits to the left of the decimal point, and two digits to the right of the decimal point; for example, 3,510.92."
I have tried: convert(money,earningsAmou
nt,1) and convert(varchar,cast(earni
ngsAmount as money),1)
both give me e.g. 1735.3400 whereas I am looking for 1,735.34
What am I doing wrong?