I use the MOD expression quite frequently in my definition queries in ESRI to extract fields that are divisible by a specific vale
MOD( [contour], 50) = 0 OR
contour = MOD(0, 50)
However I have just moved my feature class from an ESRI file geodatabase onto an ESRI SQL Server and by doing this is appears to make the MOD expression redundant.
The error that comes up when i enter in the normal MOD expression is as follows
"There was an error with the expression. Underlying DBMS error [[Microsoft][SQL Server Native Client 11.0][SQL Server]'MOD' is not a recognized built-in function name."
Has anyone experienced this and if so, were you able to find another expression that does the same thing as the MOD expression?