# MOD (SQL)

## Synopsis

{fn MOD(dividend,divisor)}

### Arguments

Argument | Description |
---|---|

dividend | A number that is the numerator (dividend) of the division. |

divisor | A number that is the denominator (divisor) of the division. |

## Description

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).

## Examples

The following example shows the remainder returned by MOD.

SELECT {fn MOD(5,3)} AS Remainder

returns 2.

The following example shows the remainder returned by MOD with a negative dividend.

SELECT {fn MOD(-5,3)} AS Remainder

returns 1.

The following example shows the remainder returned by MOD with a negative divisor.

SELECT {fn MOD(5,-3)} AS Remainder

returns –1.