AMOUNT IN WORDS

[naveen_hadagali]

Hi ALL,

Could any one guide me how to get the amount in words...
Like i have total and i want to display it in words...
Ex: if total is 1000 then i need to display it as one thousand ..

Regards
Naveen

[KVBR]

Hi, Check with this oracle statement.

select to_char(to_date(1000,'J'), 'JSP') as IN_WORDS from dual;

KVBR

[naveen_hadagali]

Thanks For your reply...let me try with that and will let you know how it worked