Wednesday, June 07, 2006

Spelling out numbers...

Allways wanted to spell out numbers Laughing? The most simple solution is using a SQL date (!) format mask:

SQL>select to_char( to_date( 12345, 'J'), 'JSP') Words from dual;
WORDS
----------------------------------------
TWELVE THOUSAND THREE HUNDRED FORTY-FIVE

There is one drawback : it works only with integers between 1 and 5373484..Frown

Post a Comment