ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

MOD function [Numeric]

Function 

Returns the remainder when one whole number is divided by another.

Syntax 

MOD ( dividend, divisor )

Parameters 

dividend    The dividend, or numerator of the division.

divisor    The divisor, or denominator of the division.

Usage 

Division involving a negative dividend will give a negative or zero result. The sign of the divisor has no effect.

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    SQL/foundation feature outside of core SQL.

• Sybase    Not supported in Adaptive Server Enterprise. The % operator is used as a modulo operator in Adaptive Server Enterprise.

See also 

REMAINDER function [Numeric]

Example 

The following statement returns the value 2.

SELECT MOD( 5, 3 )