Re: Number to Words Conversion

Hi,

You can use what bruce has suggested and get the value you want.

eg.

select trim(substring(cash_words('1520'), 1, position('dollars' in
cash_words('1520'))-1));

will return you

One thousand five hundred twenty (But ofcourse this eg. does not work for
decimals)

Regards,
Moiz Kothari

On 11/2/07, Bruce Momjian <bruce(at)momjian(dot)us> wrote:
>
> yogesh wrote:
> > Hello Frnds,
> >
> > Is there any way to Convert the Number to its equivalent String
> > ( Words)
> >
> > e.g. 10 to TEN. Urgent require the Answer..
>
> We have cash_words:
>
> test=> SELECT cash_words('100');
> cash_words
> ------------------------------------
> One hundred dollars and zero cents
> (1 row)
>
> but that is money-oriented.
>
> --
> Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
> EnterpriseDB
> http://postgres.enterprisedb.com
>
> + If your life is a hard drive, Christ can be your backup. +
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>

--
Hobby Site : http://dailyhealthtips.blogspot.com