NOROUND(a) 
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.
a |
Result of the NOROUND(a) function |
|---|---|
a is a NULL value |
NULL value |
a is a special NULL value |
Special NULL value |