Posted by Woodies_46 on 03/08/06 06:39

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.

eg.

16000000
1000
160000

TO THIS

$16,000,000.00
$1000.00
$16,000.000


I'm using MS SQL 2000

Cheers

• Next in forum: Re: ORDER BY in VIEW not working
• Prev in forum: Changing Machine Names MSDE
• Thread view: Convert VARCHAR into Money Value

[Reply to this message]