Skip to main content
4 of 4
added 33 characters in body
Bera
  • 77.8k
  • 14
  • 78
  • 188

You can use cast and like:

CAST("Somefield" AS CHARACTER(3)) NOT LIKE '18%'

See Using SQL CAST functionality in against a File Geodatabase

You might need to change the double quotation marks to single or remove them completely around your fieldname depending on your input (shapefile, feature class in fgdb, etc).

Bera
  • 77.8k
  • 14
  • 78
  • 188