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