NOROUND(a) 

NOROUND(a) is an arithmetic function that prevents the expression a of an UPDATE or INSERT statement from being rounded so that it matches 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 the NULL value	NULL value
a is a special NULL value	Special NULL value