re: Spelled-out #'s in SQL*Plus

I am sending this via a POST-ONLY account. Would someone forward this to mdickson_at_netcom.com (Mike Dickson)? Thanks,
Tom

  1* select to_char(to_date('1234567','J'), 'JSP') from dual SQL> / TO_CHAR(TO_DATE('1234567','J'),'JSP')

                                            chicago ,--------+  detroit
Tom Harleman                                        |        |
INOUG Committee Member                              |Indiana |
Paradigm Consulting, Inc.                 st.       | Oracle |
11080 Willowmere Drive                    louis     |  Users |
Indianapolis, IN  46280                             |   Group|
USA                                                 |        |
                                                    |      _,+cincinnati
INTERNET:   72072.2122_at_compuserve.com               /   _,'
Compuserve: 72072,2122                             /_,-'louisville
                                                   `

>Subject: Spelled-out #'s in SQL*Plus
>Message-ID: <mdicksonCtnsxn.IFA_at_netcom.com>
>From: mdickson_at_netcom.com (Mike Dickson)
>Date: Thu, 28 Jul 1994 16:39:23 GMT
>Organization: NETCOM On-line Communication Services (408 261-4700 guest)
>X-Newsreader: TIN [version 1.2 PL1]
>Lines: 10
>
>The SQL statement that produces a spelled-out number for a check-writing
>program died during the v6-v7 migration. We're looking for a
>general-purpose routine that will take a number and return the
>spelled-out string, ie 1234 becomes One Thousand Two Hundred and
>Thirty-Four. Anybody out there done something like this?
>--
>Mike Dickson (Dir, Information Systems) | Voice (512) 459-1000
>Lutheran Social Services of the South | Fax (512) 452-6855
>Austin, Texas USA | Internet mdickson_at_netcom.com
>"Not my employer's opinions, unless they agree with it"
Received on Thu Aug 04 1994 - 23:08:09 CEST