how to change format of amount number in sql?

Asked Dec 20 '16 at 11:33

Active Dec 20 '16 at 11:33

Viewed 98 times

how to change a format of a number to 1,214,378.00

If i have a number 1214378.00 how can I change it into 1,214,378.00 ? any help :)

asked Dec 20 '16 at 11:33

Bishoy Ezzat

Don't, please don't. You can change the way the number displays in your settings, but if you change that number to a string you will cause all manner of headaches for yourself and anyone who tries to use the data. – JohnHC Dec 20 '16 at 11:35
6

http://stackoverflow.com/questions/4377352/how-do-i-format-a-number-with-commas-in-t-sql Possible duplicate. Answer here – J.M Smith Dec 20 '16 at 11:35

0 Answers0