On 7 Aug 2006 at 9:35, Fabio Gomes 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:
>
>(value1 * value2) + (value3 * value2) / (value4 + value2)
>
>i just need it to be decimal in the end, they are all decimal values
>anyway.

You _will_ get precise decimal in the end if you use dialect 3. But
this decimal will have 12 digits after point. Any rounding will loose
precision.

--
SY, Dimitry Sibiryakov.