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.