how to display number as string

[nishasingh]

Hi,
Some body please tell me how to display 1234 as "one thousand two hundred thirty four" using sql query
Thanx& regards
Nishasingh

[sourabh]

Originally Posted by nishasingh

Hi,
Some body please tell me how to display 1234 as "one thousand two hundred thirty four" using sql query
Thanx& regards
Nishasingh

Hi nisha,

You can try out this

select to_char(to_date('1234','j'),'jsp') from dual;

i hope this will work.

regards
sourabh

[manohar999]

very simple and good one...

Manohar