[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: Sqr Help -Reply

You can design two tables to designate first: the alpha equivalents of the
digits and
secondly the positional multipliers (million, thousand, hundred, etc.)

Lynn Francis
American Bankers Association

>>> "Mark W. Salem" <MSALEM2306@AOL.COM> 02/02/97 06:19pm >>>
Thanks for responding.  Here is my question:

        Help!  I am in desperate need of a solution to converting a numeric
money field into its word equivilent; e.g.,
 $1,652.97 -->   One thousand - six hundred - fifty - two and 97/100

I am using Oracle on a Unix server with a Window's 95 client...

Any suggestions?