GO
DECLARE @x MONEY
SET @x=12345.678
SELECT CONVERT(VARCHAR, @x, 0) --12345.68
SELECT CONVERT(VARCHAR, @x, 1) --12,345.68
SELECT CONVERT(VARCHAR, @x, 2) --12345.6780
GO
DECLARE @x DECIMAL(18,6)
SET @x=12345.678
SELECT CONVERT(VARCHAR, @x, 0) --12345.678000
SELECT CONVERT(VARCHAR, @x, 1) --12345.678000
SELECT CONVERT(VARCHAR, @x, 2) --12345.678000