format a numeric values with commas -- sql server mseq

hari
9/21/2004 3:49:34 AM

hi,
I have requirement.
I want to format a numeric value with commas. is there
any function to use in transact-sql query to do this.
for example if the numeric value is 27519.37 then it
should be formatted as 27,519.37
if the numeric value is 1221512.34 then it should be
formatted as 1,221,512.34

regards,

hari
9/21/2004 8:49:54 PM

hi,

i don't know why it happened, but u can try using ur IP
instead of localhost.
ex: http:\\10.xx.xx.xx\

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server mseq

sql server mseq : format a numeric values with commas