you can also create a custom function (UDF):
select dbo.format_currency (1234), dbo.format_currency (-1234), and the results are: 1,234.00 and -1,234.00. Notice decimal delimeter.
... more at http://www.siccolo.com/articles.asp
Discussion on:
Message 1 of 1
0
Votes
Format To Currency in SQL using function
Posted by siccolo_mobile_management@...
26th Feb 2008
