Subject Re: [firebird-support] Cast of Select Sum(nds20) from repinvoice(402058)
Author Svein Erling Tysvaer
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)

HTH,
Set