|
|
Posted by Erland Sommarskog on 03/08/06 12:25
(Woodies_46@hotmail.com) writes:
> Ok i know this is simple but i just don't know the syntax. What I have
> is a bunch of values and i want to be able to display them as money
> values with a $ in front.
>
> 16000000
> 1000
> 160000
>
> TO THIS
>
> $16,000,000.00
> $1000.00
> $16,000.000
>
>
> I'm using MS SQL 2000
Normally, formatting should be done client-side. Not the least because
the format is dependent on regional settings. The above is not how I
want my decimal commas and thousands separator.
Nevertheless, you can do this:
declare @x money
select @x = 9009090909
select '$' + convert(varchar, @x, 1)
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|