ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

REMAINDER function [Numeric]

Function 

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

Syntax 

REMAINDER ( dividend, divisor )

Parameters 

dividend    The dividend, or numerator of the division.

divisor    The divisor, or denominator of the division.

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Not supported in Adaptive Server Enterprise. The % (modulo) operator and the division operator can be used to produce a remainder.

See also 

MOD function [Numeric]

Example 

The following statement returns the value 2.

SELECT REMAINDER( 5, 3 )