Follow

Data Comparison Operators

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?
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk