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
