RE: plsql algorithm to print dollar amounts in english

From: Steve McClure <smcclure_at_usscript.com>
Date: Thu, 15 May 2003 10:51:54 -0800
Message-ID: <F001.00599FF3.20030515105154@fatcity.com>

That is an ingenious use of the to_date/to_char. Just a couple of mods, and it will do everything I need.

Thanks a ton,
Steve McClure

-----Original Message-----

Jared.Still_at_radisys.com
Sent: Wednesday, May 14, 2003 7:12 PM
To: Multiple recipients of list ORACLE-L

Check out:

http://asktom.oracle.com/pls/ask/f?p=4950:8:170839601567030223::NO::F4950_P8 _DISPLAYID,F4950_P8_CRITERIA:1407603857650, Jared

"Steve McClure" <smcclure_at_usscript.com>
Sent by: root_at_fatcity.com
 05/14/2003 06:46 PM
 Please respond to ORACLE-L

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc:
        Subject:        plsql algorithm to print dollar amounts in english

Listers,

I have just been asked if I know of a resource for an algorithm to print numeric dollar amounts out in english. This is for a check writing program,
and way back in the day I actually put one of these together for a client. I don't have that code any more, and in any event would like to avoid recreating the wheel. I am certian lots of folks have addressed this issue,
I am hoping to find a published algorithm out there that will at least keep
me from starting from scratch. My initial Google searches have not been productive, so I figured I would try here for a tip.

Any help is appreciated.

Thanks,

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).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author:
  INET: Jared.Still_at_radisys.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).

--

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). Received on Thu May 15 2003 - 13:51:54 CDT