Re: Numeric to Character Conversion (e.g. 10 to TEN)

Try sthing like this(?)

select

decode(trunc(100),0,null,to_char(to_date(trunc(100),'yyyy'),'year')) from dual;

On 19 Jan 1998 15:16:54 GMT, oracle_at_tchp2.tcamuk.stratus.com (Neil Chandler) wrote:

>I don't suppose that anyone has come up against a function to
>decode numeric numbers into verbal numbers.
>
>e.g. 10 converts to Ten
> 2105 converts to Two thousand one hundred and five
>
>I have a couple of programmers insisting that they have come across such a
>function before.
>
>regards
>
>Neil Chandler

Kaboel Karso

Consultant

                                                           \\\|///
                             \\  ~ ~  //
                             (  @ @  )
==========================-oOOo-(_)-oOOo-===================

eSCOSYS Consultancy		Phone	: +31 (0)32 024 7285
Horst 2827			Fax	: +31 (0)32 024 7286	
8225 MZ Lelystad		Mobile	: +31 (0)65 498 5413
The Netherlands			email	: kkarso_at_knoware.nl

==================================-Oooo.-===================
                         .oooO     (   )
                          (   )      ) /
                           \ (      (_/