Hi,

If you have the Data in Sql table like

Value

15

17

Now, If you want to print the values like $15 and $17. So you will have to do like this…

SELECT LEFT(‘$’ + CONVERT(VARCHAR, CAST(’15.00′ AS MONEY), 1), LEN(‘$’+ CONVERT(VARCHAR, CAST(’15.00′ AS MONEY), 1)) – 3)