This question already has an answer here:
I have data like multiples of 40.
and so on.
I would like to label every record that is a multiple of 100.
I have tried a couple of methods and cant 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.
Does anyone see what I am doing wrong?
respectfully I did search and did not see any of the example questions you presented.
However it still does not answer my question.
What am I doing wrong.