A comparison operator is the test to perform against the selected field and the value you provide. Not all operators work with every field type. The 'LIKE' and 'NOT LIKE' operators compare a Text field to a text string. These operators require a string value that includes a percent symbol ( % ) to act as a wild card for searching.
The following table defines each operator and the supported field types:
|
Operator |
Type(s) |
Description |
|
IN |
Float, Number, Date, Text |
Is the field included in the list of values? This is like creating several OR conditions with one condition. |
|
NOT IN |
Float, Number, Date, Text |
Is the field not included in the list of values? This is like creating several AND NOT conditions with one condition. |
|
= |
Float, Number, Date, Text |
Is the field equal to the value? |
|
!= |
Float, Number, Date, Text |
Is the field not equal to the value? |
|
> |
Float, Number, Date |
Is the field greater than the value? |
|
Float, Number, Date |
Is the field less than the value? |
|
|
>= |
Float, Number, Date |
Is the field greater than or equal to the value? |
|
= |
Float, Number, Date |
Is the field less than or equal to the value? |
|
LIKE |
Text |
Is the field like the text string? Contains: %string% Begins With: string% Ends With: %string |
|
NOT LIKE |
Text |
Is the field not like the text string? Does Not Contain: %string% Does Not Begin With: string% Does Not End With: %string |
|
IS NULL |
Float, Number, Text, Date |
Is the field NULL, or does it not exist? |
|
IS NOT NULL |
Float, Number, Text, Date |
Is the field not NULL, or does it exist? |