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
