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. |