I'm trying to add a custom SQL query to my labeling class and it doesn't like the modulo operator (%). It works in the definition query for the layer, but when I try to use it for a labeling class it doesn't like it. The name of the field I'm using in the query is "MRL_MEAS", and the query I'm trying to use is "MRL_MEAS % 1 = 0", because I want to only label the numbers divisible by 1. When I click the green check mark to validate it, it validates. But when I click "Apply", it says "The SQL expression has invalid syntax". This query should work. Again, it works in the definition query for the layer. This just seems to be a bug with the labeling classes. Has anyone else experienced this or know if I'm doing something wrong? ArcGIS Ideas
... View more