A scalar numeric function that returns the modulus (remainder) of a number divided by another.

{fn MOD(dividend,divisor)}

MOD returns the mathematical remainder (modulus) from the dividend by the divisor. It returns a negative or zero result for a division involving a negative divisor. MOD returns NULL if passed a NULL value for either argument.

MOD can only be used as an ODBC scalar function (with the curly brace syntax).

The following example shows the result of MOD.

SELECT {fn MOD(5,3)}

returns 2.

The following example shows the result of MOD with a negative dividend.

SELECT {fn MOD(-5,3)}

returns 1.

The following example shows the result of MOD with a negative divisor.

SELECT {fn MOD(5,-3)}

returns –1.

TRUNCATE