Function documentationNOROUND(a) Locate this document in the navigation structure


NOROUND(a) is an arithmetic function that prevents the expression a of an UPDATE or INSERT statement from being rounded to match the data type of the target column.

If the non-rounded number does not correspond to the data type of the target column, an error message is output.



Result of the NOROUND(a) function

a is a NULL value

NULL value

a is a special NULL value

Special NULL value