Home Library Learn Downloads Support Community
Sign in | United States - English | |
1 out of 1 rated this helpful - Rate this topic

% (Modulo) (SQL Server Compact)

Provides the remainder of one number divided by another.

Copy 

dividend % divisor
dividend

The numeric expression to divide. The dividend can be any valid expression in Microsoft SQL Server Compact of the integer data type category.

divisor

The numeric expression to divide the dividend by. The divisorcan be any valid SQL Server expression of any of the data types of the integer data type category.

The following example uses modulo to identify employees with even-numbered EmployeeID values.

Copy 
SELECT EmployeeID, LastName, EmployeeID % 2 FROM Employees WHERE EmployeeID % 2 = '0'

This is the result set:

Copy 
EmployeeID   LastName   #2
----------   --------   ---
2            Funk     0
4            Pearson    0
6            Sutton     0
8            Calafato   0
Did you find this helpful?
(1500 characters remaining)