InterSystems SQL Reference
MOD


A scalar numeric function that returns the modulus (remainder) of a number divided by another.
Synopsis
{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. The value returned is of data type NUMERIC.
MOD can only be used as an ODBC scalar function (with the curly brace syntax).
The following example shows the remainder returned by
MOD.
SELECT {fn MOD(5,3)} AS Remainder
The following example shows the remainder returned by
MOD with a negative dividend.
SELECT {fn MOD(5,3)} AS Remainder
The following example shows the remainder returned by
MOD with a negative divisor.
SELECT {fn MOD(5,3)} AS Remainder