RE: convert number to word ???

-----Original Message-----
AK
Sent: Friday, August 22, 2003 3:09 PM
To: Multiple recipients of list ORACLE-L

>some where I got this
>
>create or replace
>function spell_number( p_number in number )
>return varchar2
>.
>.
>.

That is the same routine i was directed to a few months back when I asked this question. It is from the "ask tom" site. It worked perfectly, and the use of to_date was brilliant and elegant. Seeing routines like that reminds me of just how far I have to go to be good at what I do.

Steve McClure

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Steve McClure
  INET: smcclure_at_usscript.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).