Adding thousand-separator commas to numbers:

SELECT CAST(CONVERT(varchar, CAST(123456 AS money), 1) AS varchar)

Limiting decimal points:

SELECT CAST(100000.456789 AS decimal(12,2))