Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Returns the remainder when one whole number is divided by another.
MOD( dividend, divisor )
The dividend, or numerator of the division.
The divisor, or denominator of the division.
Division involving a negative dividend gives a negative or zero result. The sign of the divisor has no effect.
The following statement returns the value 2:
SELECT MOD( 5, 3 );