Returns the remainder of expression1 divided by expression2.

Syntax

MOD ( expression1 , expression2 )

Notes

  • Both expression1 and expression2 must evaluate to exact numeric data types.
  • If expression2 evaluates to zero, MOD returns zero.

Example

This example illustrates the MOD function:

SELECT MOD (11, 4) 'Modulus' FROM MYMATH;

Compatibility

ODBC compatible