Subject Re: [firebird-support] query Integer overflow
Author Dimitry Sibiryakov
23.06.2019 5:41, 'Mr. John' mr_johnmr@... [firebird-support] wrote:
> The calculation is on a SP code and I need it there

Then get rid of IIF and decide at which moment you need round intermediate values. Then
cast the values to types with smaller precision.