cedar72
Say Hey Kid
Points: 711
More actions
October 22, 2002 at 8:06 am
#80038
My boss has come to me and asked if it is possible to turn a number into full text...for example 301 into 'Three hundred and one'. I've never seen this done...is it possible?
sjcsystems
Ten Centuries
Points: 1347
October 22, 2002 at 8:14 am
#439126
Yes, it's definitely possible - I wrote a function in FoxPro to do this for printing onto cheques - I suggest a function in SQL would be possible
Greg Larsen
SSC-Insane
Points: 20961
October 22, 2002 at 8:18 am
#439127
Check this script out:
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=259
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply