display int as words

I want to display integers a words (eg: display 4 as four). How do i do this. pl help. savio pereira

Informix news groups wrote: > I want to display integers a words (eg: display 4 as four). How do i do > this. pl help. > > savio pereira The following program may be what you are looking for: fmt_mony.4gl - This 4gl program contains code which converts a number stored in a money variable into text (eg. $10.00 to TEN DOLLARS). It can be downloaded from: ftp://ftp.iiug.org/pub/informix/usergrps/denver_co_usa/fmt_mony.4gl -- Compliments of QueriX -------------------------------------------------------------------------------------------------- QueriX 4GL Compilers are Informix 4GL Compatible, and Connection to other RDBMS such as Oracle. Hydra 4GL Compiler (Compatible with I4GL) Compile once, run everywhere Phoenix Windows GUI. (Front End to 4GL) Chimera Java GUI The only GUI you will ever need... (Front End to 4GL) Arachne Web Technology (Front End to 4GL on the Web & HTML Report Generator) ESQL/C Compiler For more details visit: http://www.querix.com/ ---------------------------------------------------------------------------------------------------

Informix news groups wrote: > > I want to display integers a words (eg: display 4 as four). How do i do > this. pl help. Version, platform, and front-end tool? Using IDS 7.31 you can use the CASE statement to replace simple numbers (like 4) with words if all of the possible values are predictable. Using IDS.2000 (9.2x) you could write a UDF to make the conversion in the general case and SELECT the result of that function. If your front-end is a 4GL or ESQL/C application you can always code the conversion into the app and make the conversion for display there. -- Art S. Kagel & Family kagel@erols.com