AnsweredAssumed Answered

Modulo operator in SQL query not working for labels in Pro 2.3.1?

Question asked by Tony.Grossman on Mar 13, 2019
Latest reply on Mar 14, 2019 by tpcolson

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 

 

Outcomes