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.