Return Numerics with Commas

Replace @x with the field or variable you want formatted

replace(convert(varchar(25), convert(money, @x), 1), '.00', '')