use 1000 seperator for my price column

hi
i have a question about one of my column in table
i have a float column --> price
i wanna use 1000 seperator for my price column
how can i do that
tanxfull
Mahsa
Mahsa60Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Ryan ChongConnect With a Mentor Commented:
Try like:

Select CONVERT(varchar, CAST(myprice AS money), 1) from mytable
0
 
curtis591Commented:
Your front end application would have to format it.
0
 
jdlambert1Commented:
Both front-end and cast-to-money/convert-with-style-1 will work. If you have a small amount of data to deal with, performance difference will be insignificant. If you have millions of records to work with, a well-written front-end formatting is likely to give the best performance, since it can do it in a single function, rather than 2 functions.
0
All Courses

From novice to tech pro — start learning today.