This document is archived and information here might be outdated.  Recommended version.


esriSQLPredicates Constants (ArcObjects .NET 10.4 SDK)
ArcObjects Library Reference (GeoDatabase)  

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.

Product Availability

Available with ArcGIS Engine, ArcGIS Desktop, and ArcGIS Server.