From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Svein Erling
Tysvaer
Sent: Friday, December 08, 2006 12:39 PM
To: Firebird-support
Subject: Re: [firebird-support] Cast of Select Sum(nds20) from
repinvoice(402058)



Kirill S. Palagin wrote:

> Hello everybody.
>
> (Please help newby with expression, our developer is on

vacation)

> I need to
> cast "Select Sum(nds20) from repinvoice(402058)" as

numeric(15,2)

> , but nothing I have constructed so far seems to work

(repinvoice is

> procedure).
>
> Thanks a lot.
> WBR,
> K. Palagin.

What about something like

Select Sum(cast(nds20 as decimal(15,2))) from repinvoice(402058)

That should work too.
Thanks a lot!
WBR,
K. Palagin.