Subject RE: [firebird-support] Numeric(18,4) calculations
Author Maya Opperman
>>So adjust your multiplication and division expressions accordingly,
>>using CAST or a rounding algorithm, according again to business
>>requirements.

Let's say your business requirements are for the result to be rounded to
4 decimal places.

Can you give an example statement which would not cause an overflow?

(I too have this problem, and I'm not quite sure which value to cast
where and when)



Thanks

Maya





[Non-text portions of this message have been removed]