Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 Other Topics
 Printing numbers in words.

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-06-17 : 14:12:13
Ritesh writes "I want to print the numbers in words as output.
Is it posible to print numbers in words using a single query? If it is posible then can somebody help me?

Ex. Input = 101.75
Output = One Hundred One Dollars and Seventy Five Cents.

Thanks,
Ritesh"

jasper_smith
SQL Server MVP & SQLTeam MVY

846 Posts

Posted - 2002-06-17 : 18:04:37
It might be argued that this is more a client side issue however here are a couple of useful links.

[url]http://groups.google.com/groups?hl=en&lr=&ie=UTF8&oe=UTF8&selm=3C31EF37.6570D7CE%40drew.edu&rnum=3[/url]

[url]http://www.xephon.com/oldcode/Q014A05[/url]

HTH
Jasper Smith

Go to Top of Page

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2002-06-25 : 12:43:37
I knew this was out there somewhere.....it just took a bit of searching for it....



http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=11157

Go to Top of Page
   

- Advertisement -