| ComparisonOperator | Value | Description |
|---|---|---|
| EQUAL | 0 | == (exact match for strings, case sensitive) |
| NOT_EQUAL | 1 | != |
| GREATER_THAN | 2 | > |
| GREATER_THAN_OR_EQUAL_TO | 3 | >= |
| LESS_THAN | 4 | < |
| LESS_THAN_OR_EQUAL_TO | 5 | <= |
| STRING_PATTERN (for string datatype only) | 6 | '?' is a wildcard for one character, "*" is a wildcard for many characters |
Warning In the current version V1.0, only the comparison operators EQUAL, NOT EQUAL, and STRING PATTERN are supported. Exercise caution when using any other operators.