...
| Comparator | Evaluates to True when... | Types handled |
|---|---|---|
| _LESS_THAN | item 1 is less than item 2 | numeric, alphabetic |
| _GREATER_THAN | item 1 is greater than the item 2 | numeric, alphabetic |
| _EQUALS | item 1 is identical to the item 2 | numeric, alphabetic |
| _GREATER_THAN_OR_EQUAL | item 1 is identical to or greater than the item 2 | numeric, alphabetic |
| _LESS_THAN_OR_EQUAL | item 1 is identical to or less than the item 2 | numeric, alphabetic |
| _NOT_EQUALS | item 1 is not identical to the item 2 | numeric, alphabetic |
| _STARTS_WITH | item 1 starts with the string specified in item 2 | alphabetic |
| _NOT_STARTS_WITH | item 1 does not start with the string specified in item 2 | alphabetic |
| _LIKE | item 1 is like the item 2 | alphabetic |
| The following comparators, _IS_NOT_NULL and _IS_NULL, only have 1 item, which is compared to null. | ||
| _IS_NOT_NULL | item 1 is a non null string or value. | numeric, alphabetic |
| _IS_NULL | item 1 is null. | numeric, alphabetic |
...