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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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