Entrypoint softround compatible with UTF-8
Input DOUBLE floatingpoint to be round INTEGER number of digits to be round Output INTEGER floatingpoint rounded to integer
The method of rounding is similar to F_ZAHLRUNDEN. If the result of rounding would be 0, than the result is the non-rounded value. TestSQL SELECT 0.0016 AS ISCORRECT, F_SOFTROUND(0.0016, 2), F_ZAHLRUNDEN(0.0016, 2) FROM RDB$DATABASE; SELECT NULL AS ISCORRECT, F_SOFTROUND(NULL, NULL) FROM RDB$DATABASE;