Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

REMAINDER function [Numeric]

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

REMAINDER( dividend, divisor )

dividend    The dividend, or numerator of the division.

divisor    The divisor, or denominator of the division.

Alternatively, try using the MOD function.

• MOD function [Numeric]

• SQL/2003    Vendor extension.

The following statement returns the value 2.

SELECT REMAINDER( 5, 3 );