Jarosław Kozik (jk****@op.pl) writes:
How to formatting numeric value like 20,5 to money value like 20,50 USD
using MS SQL server 2000
replace(ltrim(str(@val, 17, 2)), '.', ',') + ' USD'
But you are really better off doing this client-side where you can format
to the client's regional settings etc.
--
Erland Sommarskog, SQL Server MVP,
es****@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx