thanks for the tip Dimitry On Sunday, June 23, 2019, 11:38:04 AM GMT+3, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] <firebird-support@yahoogroups.com> wrote: 23.06.2019 5:41, 'Mr. John' mr_joh...@yahoo.com [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. -- WBR, SD. ------------------------------------ ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ------------------------------------ Yahoo Groups Links