SQL Query to insert Thousand Separators in Numeric Value

SQL Query to insert Thousand Separators in Numeric Value

SELECT REPLACE(CAST(CONVERT(varchar, CAST(123006 AS money), 1) AS varchar),'.00', '')