Proper Formatting of Money in T-SQL
'$'+PARSENAME(CONVERT(varchar,CONVERT(money,sum(yourColumnName)), 1),2)
ParseName function got rid of my trailing zero’s. the rest explains itself.
uncoditional
code liberated
'$'+PARSENAME(CONVERT(varchar,CONVERT(money,sum(yourColumnName)), 1),2)
ParseName function got rid of my trailing zero’s. the rest explains itself.
