Print Page - AMOUNT IN WORDS

Title: AMOUNT IN WORDS
Post by: naveen_hadagali on 01 Aug 2007 05:27:48 AM

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

Title: Re: AMOUNT IN WORDS
Post by: KVBR on 02 Aug 2007 02:20:36 AM

Hi, Check with this oracle statement.

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

KVBR

Title: Re: AMOUNT IN WORDS
Post by: naveen_hadagali on 02 Aug 2007 03:38:20 AM

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

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: naveen_hadagali on 01 Aug 2007 05:27:48 AM