SQL Functions

$MOD

Returns "n modulus y". This is the remainder of n divided by y.

"n" and "y" may be a column , expression, or literal. The return value is INTEGER length 4.

Syntax

$MOD( <column-spec | expression | constant >, <column-spec | expression | constant > )

$MOD()

Required.

n

Required. This can be a column, expression, or constant.

y

Required. This can be a column, expression, or constant.

top

Example

$MOD(1995, 4)

3

top