|
Home > Archive > MS SQL Server ODBC > March 2006 > Convert VARCHAR to money value
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Convert VARCHAR to money value
|
|
| Woodies_46@hotmail.com 2006-03-08, 3:23 am |
| 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
| |
| ranjitjain via SQLMonster.com 2006-03-08, 3:23 am |
| I guess it's not straight forward by just using convert function to change
datatype to money.
You need to write a function which will append $ and will separate thousands
with comma.
Woodies_46@hotmail.com wrote:
>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
--
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Fo...tivity/200603/1
|
|
|
|
|