MS SQL 2000 formatting numeric value to money

How to formatting numeric value like 20,5 to money value like 20,50 USD
using MS SQL server 2000

regards IJKKJarosaw Kozik (jkozik@.op.pl) writes:

Quote:

Originally Posted by

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, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx