Re: Resend - Numbers to Alpha

From: <joseph_testa_at_aep.com>
Date: 1998/02/24
Message-ID: <6cuvhm$r8b$1_at_nnrp1.dejanews.com>#1/1


go to my web page, the script is on there:

http://www.oracle-dba.com

look at the oracle scripts link, it is near the bottom of that page, joe

In article <34F2C722.3720A6ED_at_alliedsignal.com>,   101, Columbia, Rd., Morristown, NJ, 07960 wrote:
>
> Does anyone have a pl/sql or sql routine to convert (for display and
> printing) fields that contain a number?
> For example, if the field contains: 1105.75 I need to display/print:
> ONE THOUSAND ONE HUNDRED FIVE DOLLARS and 75 CENTS.
> I'm sure I've seen it and I know I can do it, but why re-invent the
> wheel?
> Thanks,
> Joe Nametko
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue Feb 24 1998 - 00:00:00 CET

Original text of this message