Re: SQL Number to Text Conversion

Hi,

SELECT TO_CHAR(to_date(2972,'J'), 'JSP')

   FROM DUAL; HTH, Erika

Colin Sheppard wrote:
>
> Hello,
>
> I was wondering if you can direct me to some ORACLE PL/SQL code/builtin
> function, or a web site that converts a numeric value into text, and/or
> vice-versa? For example:
>
> '2972'
>
> would be
>
> 'two thousand nine hundred and seventy two'
>
> Thank you for your kind attention and assistance,
>
> Cheers,
>
> Colin Sheppard,
> IT Solutions Specialist,
> Agilent Technologies,
> Singapore.
Received on Fri Jan 28 2000 - 11:28:40 CET