Data Type | Search Operator | To Return Records with Values That... | Case-Sensitive | |
Text | Exactly | = | Are an exact match | No |
Contains | LIKE | Contain the specified phrase | No | |
Does not Contain | Do not include the specified phrase | No | ||
Begins with | Start with the specified phrase | No | ||
Ends with | End with the specified phrase | No | ||
All of the words | Contain all the specified words | No | ||
Is Empty | Contain null value | N/A | ||
Is not Empty | Does not contain null value | N/A | ||
Numeric and Date | Exactly | = | Are an exact match | N/A |
Greater Than | > | Are greater than the specified value | N/A | |
Less Than | < | Are lesser than the specified value | N/A | |
Between | BETWEEN | Fall within the specified range of values | N/A | |
Not Equal | Are not an exact match to the specified value | N/A | ||
Is Empty | Contain null value | N/A | ||
Is not Empty | Does not contain null value | N/A | ||
Boolean expression | Yes | Contain Yes | N/A | |
No | Contain No | N/A | ||
Reference columns | Exactly | = | Are an exact match | N/A |
Is Empty | Contain null value | N/A | ||
Is not Empty | Does not contain null value | N/A |