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.