For a check-writing application, I need to convert numbers to words using a DB2 SQL function.
As you would expect, '23456' should translate to 'Twenty three thousand four hundred fifty six'.
Thinking that would be relatively straight-forward, I first tried to write it myself, but I quickly found that it wasnt as easy as I had anticipated.
So, then I tried searching Google for it "Surely, SOMEONE has had to do this before", I thought. Unfortunately, all I could find were MS SQL Server versions that didn't easily translate to DB2 syntax. I'm using DB2 for i ... version 6.1 ... a.k.a. V6R1.
So, before I go back to trying to write this myself, does anyone have this already written? Could you please supply this middle-aged DB2 guy the logic?
Thanks VERY much!