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


regards IJKK

Jarosław Kozik (jkozik [at] 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( [at] 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 [at] sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downlo ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx