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 <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> You can use what bruce has suggested and get the value you want.
>
> eg.
>
> select trim(substring(cash_words('1520'), 1, position('dolla
Hi,
So how would it look like if you say "1520.50" what should it return you
back?
Regards,
Moiz Kothari
On 11/2/07, Yogesh Arora <[EMAIL PROTECTED]> wrote:
>
> 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 < [
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
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
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..
(column sizes just an example)
CREATE TABLE integer_string (
number SMALLINT NOT NULL,
word VARCHAR(24) NOT NULL
);
brian
---
Hello Frnds,
Is there any way to Convert the Number to its equivalent String
( Words)
e.g. 10 to TEN. Urgent require the Answer..
Regards,
Yogesh Arora
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http:/
