You should be able to use cast and like: CAST("Somefield" AS CHARACTER(3)) NOT LIKE '18%' See [Using SQL CAST functionality in against a File Geodatabase][1] [1]: https://community.esri.com/thread/49756