Query Builder Statement Operators

When you add a conditional statement, you must select an operator. The operator is used to determine whether or not a record meets the criteria defined in a conditional statement. When you add a conditional statement, the default operator and other available operators depend on the Query Builder Field Type Conventions.

The following table describes all of the possible operators.

Operator	Selects a record if the applicable field contains a value that:
Starting With	Starts with the value defined in the Value is box.
Contains	Contains the string defined in the Value is box.
(=) equal to	Equals the value defined in the Value is box.
(<>) not equal to	Is not equal to the value defined in the Value is box.
(<) less than	Is less than the value defined in the Value is box.
(<=) less than or equal to	Is less than or equal to the value defined in the Value is box.
(>) greater than	Is greater than the value defined in the Value is box.
(>=) greater than or equal to	Is greater than or equal to the value defined in the Value is box.
In	Contains one of the strings defined in the Value is box, such as an embedded literal OR statement. You must use quotation marks around any values to indicate what it should search for.
does not contain data	Is null (contains no value).
does contain data	Is not null (contains any value).
within last xxx days	Is a date within the last "xxx" days (past). Enter either an integer or two integers separated by a comma for a date range.
within next xxx days	Is a date within the next "xxx" days (future). Enter either an integer or two integers separated by a comma for a date range.