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
 SQL Server 2000 Forums
 SQL Server Development (2000)
 String Function

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-02-28 : 08:20:07
mala writes "Hi,

I there string function to spell the number. I mean If I pass 1998 as a value, it should give me nine thousand nine hundred ninty eight. If no functions available , how can i do the same.

Thanks in advance.

Bye,
Mala"

KnooKie
Aged Yak Warrior

623 Posts

Posted - 2002-02-28 : 09:13:59
Try this link:

http://www.coderoom.com/datapro_vb2.html

You want the zip file called num2text. VB5 code, so you'll have to adapt it to read in your recordsets or whatever you want to do.

Go to Top of Page

Arnold Fribble
Yak-finder General

1961 Posts

Posted - 2002-02-28 : 11:51:48
This any help?
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=11157


Go to Top of Page
   

- Advertisement -