Why is MOD(OBJECTID,30)=0 an invalid expression? I have a feature class with a field 'OBJECTID', it appears automatically when typing the SQL syntax. I tried this in v2.4 and 2.3. Both places it says invalid syntax. It works, however, in another map. The first OBJECTID value is 281. There are 290 records. If i create another field (LONG data type) and subtract 280 from the OBJECTID field and put the result in this new field, so it starts at 1, and then use that field in the MOD expression, it still fails. The data comes from a SDE.
... View more