MOD

Returns the remainder of one number divided by another number.

Syntax

MOD (dividend, divisor)

Arguments

dividend - the numeric expression to divide. The dividend must be a valid expression of any numeric data type.

divisor - the numeric expression by which to divide the dividend. The divisor must be any valid expression of any numeric data type.

Examples

The following example searches for all users with the odd roomNumber attribute.

SELECT $roomNumber FROM "OU=Users,DC=company"
WHERE $objectCategory='Person' AND $objectClass='user'
    AND EXISTS $roomNumber AND MOD($roomNumber,2)>0;