How can I get a number with a thounds separator on

Question

SELECT count(*) FROM table A

let's say the result is 8689. How can I convert it to 8'689 on the SQL Server?

Answer 1

Try This way:-

select replace(convert(varchar,convert(Money,  count(*)),1),'.00','') 
from table_name

and be sure you really need this approach, formatting the application is the usual and best as SqlZim said.

UPDATE:-

for setting the separator on top, Try the next:-

select replace( replace(convert(varchar,convert(Money,  count(*)),1),'.00',''),',','''')
from table_name