Subject Re: Round values in stored procedure
Author Adam
--- In firebird-support@yahoogroups.com, "Fabio Gomes" <fabioxgn@...>
wrote:
>
> I dont know if i cast would do, i m really new to firebird.. what i
m doing
> is just a simple calculation using some numeric(14,4) fields, i just
need
> the values to be correct, i dont care what to use, i ll calc
something like
> this:
>

Try:

Cast((value1 * value2) + (value3 * value2) / (value4 + value2) as
Numeric(14,2))

Adam