convertinig numeric value into words

Database
Enthusiast

convertinig numeric value into words

hi ppl,

I want to convert a column with numeric values into its equivalent words.
eg:

Col1 value is already present in the table...we need to generate col2 values as given below:

col1 col2
---- ----
290 Two hundred and ninety
23 Twenty three
.
.
.
so on for all numbers which can range anywhere between 0 to infinity.

It would be gr8 if any of u could help me with this....

Regards,

Rock

1 REPLY
rgs
Enthusiast

Re: convertinig numeric value into words

You can write a UDF to do that. If you need source code examples do a goggle search on "convert number to words" and you will get all sort of hits.