Re: Number to Words Conversion

["Yogesh Arora" <yogesh.arora.daffodil@xxxxxxxxx>]

Hi,

   As i am Working for Decimal Formats.....  is there any method to do it in the same way.

On 11/2/07, Moiz Kothari < moizpostgres@xxxxxxxxx> wrote:

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@xxxxxxxxxx> 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@xxxxxxxxxx>        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

-- 
Best Regards,
Yogesh Arora