esriSQLPredicates Constants

SQL Predicates.

Constant Value Description
esriSQL_​EQ 1 SQL Equal.
esriSQL_​NOT_​EQ 2 SQL Not Equal.
esriSQL_​LT 4 SQL Less Than.
esriSQL_​GT 8 SQL Greater Than.
esriSQL_​LE 16 SQL Less Than or Equal.
esriSQL_​GE 32 SQL Greater Than or Equal.
esriSQL_​BETWEEN 64 SQL BETWEEN.
esriSQL_​NOT_​BETWEEN 128 SQL NOT BETWEEN.
esriSQL_​IN 256 SQL IN.
esriSQL_​NOT_​IN 512 SQL NOT IN.
esriSQL_​LIKE 1024 SQL LIKE.
esriSQL_​NOT_​LIKE 2048 SQL NOT LIKE.
esriSQL_​IS_​NULL 4096 SQL IS NULL.
esriSQL_​IS_​NOT_​NULL 8192 SQL IS NOT NULL.
esriSQL_​EXISTS 16384 SQL EXISTS.
esriSQL_​NOT_​EXISTS 32768 SQL NOT EXISTS.
esriSQL_​SIMILAR_​TO 65536 SQL SIMILAR TO.
esriSQL_​NOT_​SIMILAR_​TO 131072 SQL NOT SIMILAR TO.

Your browser is no longer supported. Please upgrade your browser for the best experience. See our browser deprecation post for more details.

You can no longer sign into this site. Go to your ArcGIS portal or the ArcGIS Location Platform dashboard to perform management tasks.

Your ArcGIS portal

Create, manage, and access API keys and OAuth 2.0 developer credentials, hosted layers, and data services.

Your ArcGIS Location Platform dashboard

Manage billing, monitor service usage, and access additional resources.

Learn more about these changes in the What's new in Esri Developers June 2024 blog post.

Close