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)

Advertisements
Tags: ,

Advertisements

Calendar

February 2018
M T W T F S S
« Jan    
 1234
567891011
12131415161718
19202122232425
262728  

Stats Of Blog

  • 7,290 hits

Cluster Map