3. Appendix C: Operators

Equals

Compares a field’s value and returns any data that matches EXACTLY.

Contains Matching Substring

This operator checks if a field contains a specific, case-sensitive substring.

Contains Matching Substring (Ignore Case)

This operator is identical to Contains Matching Substring, except it is not case-sensitive.

Greater Than

Returns information where the field value is ‘greater than’ the value specified. For dates, beyond a given date or later than a given date; For text fields, this means higher strings (for example “oranges” is Greater Than “bananas”).

Greater Than Or Equal To

Greater Than or Equal To is identical to Greater Than, except it also returns data that is equal to your parameter.

Less Than

Returns information where the field value is ‘less than’ the value specified. For dates, before a given date; For text fields, this means lower strings (for example “bananas” is less than “oranges”).

Less Than Or Equal To

This operator is identical to Less Than except it returns information that is equal and less than.

In List

Enables you to pick from a list of choices.

Not In List

Not In List is the opposite of In List – Enables you to exclude from a list of choices.

Between

Between requires you to specify two parameters; mostly used for date ranges.

Not Between

Like Between, Not Between requires you to specify two parameters; it returns TRUE for fields that are not between your parameters.

Is NULL

Is NULL returns values that hold no data. It is recommended to use Is NULL or Blank instead of Is NULL.

Is Not NULL

Returns data that hold some data.

Is NULL or Blank

Is NULL or Blank returns TRUE for fields that either hold no data or do hold 'empty' data.

Is Not NULL or Blank

This operator returns TRUE for fields that hold some non-trivial data.