Vinit Patel

Posts Tagged ‘$

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)

Tags: ,

Calendar

May 2017
M T W T F S S
« Jan    
1234567
891011121314
15161718192021
22232425262728
293031  

Stats Of Blog

  • 6,792 hits

Cluster Map