T-SQL Tips : Formatting Numbers 23 February 2005 at 00:00

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))