Return Numerics with Commas

28 02 2007

Replace @x with the field or variable you want formatted

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

Comments : Leave a Comment »

Categories : Formatting, SQL Formatting, SQL Server