Query syntax to select every multiple of nn record (shapefile) using ArcMap [duplicate]

Question

I have data like multiples of 40.
40
80
120
160
200
and so on.

I would like to label every record that is a multiple of 100. I have tried a couple of methods and can't get them to work either as a query in the label or as a select statement.

"STATION" =  %00  
RIGHT ("STATION", 2) =  00

I get invalid SQL statement.

What am I doing wrong?

Answer 1

Use the MOD function, which returns the remainder after division:

MOD("STATION",100) = 0

Here's an example, in which I've selected all the records having an ADMINID which is a multiple of 10: