Member Selection Comparators

This topic describes the meaning of comparator symbols when using a selection criterion such as

The comparator is in the middle drop-down and in this example it's an equals sign (=).

The comparator symbols are the same regardless of a field's data type but their interpretations may differ as shown by the following tables.

Numbers

Comparator	Interpretation
=	equal to
>	greater than, more than
<	smaller than, less than
>=	greater than or equal to, not less than
<=	smaller than or equal to, not more than
≠	not equal to

Dates

Comparator	Interpretation
=	on this date
>	later than, after
<	earlier than, before
>=	on or after
<=	on or before
≠	not on this date

Yes/No

Comparator	Interpretation
=Yes, ≠No	yes, true, ticked, checked, selected
≠Yes, =No	no, false, not ticked, not checked, not selected

Text, Dropdown

Comparator	Interpretation
=	exactly the same as
>	Rarely used. The collating sequence is utf8.
<
>=
<=
≠	not the same as
[]	contains (Text data type only) Examples: if something [] 'to' stone true tons true pronto true get out false
][	does not contain (Text data type only)

Notes

• Comparisons are not case sensitive.
• Blank fields are ignored in searches.
• Contains and not contains are implemented with SQL LIKE and NOT LIKE respectively. Escape wildcards with \. Read about the LIKE operator at W3Schools