UDF for converting Numbers to Words 1

[kajarekar]

Can anybody provide me with a user defined function in SQL 2000 which will convert a given number to words. e.g. If the input to this function is 152.26 (Numeric) then the output should be One Hundred Fifty Two and Twenty Six (Text). I want to use this UDF in one of the Business intelligence Tools.

thanks in advance

 

[tlbroadbent]

Check the following. You should be able to modify the code to meet your needs.

http://www.users.drew.edu/skass/sql/namemoney.sql.txt

Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[kajarekar]

Thanks Terry for the help

the UDF that u suggested works fine.

 

[harmmeijer]

Looks good, still have to try it.
You get a * anyway.