sql number format and sql format number

Creating user defined number format function to


dbo.format_number (1234), dbo.format_number (-1234.05), results are:
1,234 and -1,234.

sql currency format and sql format currency

Creating user defined currency format function to


select dbo.format_currency (1234), dbo.format_currency (-1234.05), results are:
1,234.00 and -1,234.05.

Format to "Currency" with SQL

see it at Siccolo Articles - How to Create SQL Function To Format To Currency