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.
You can also use the MOD function to return the remainder.
SQL/2008 Vendor extension.
The following statement returns the value 2.
SELECT REMAINDER( 5, 3 );