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	Aggregate Calculated Field Conditions tab symbols	Selects a record if the applicable field contains a value that:
Starting With	LIKE ‘value%’	Starts with the value defined in the Value is box.
Contains	LIKE ‘%value%’	Contains the string defined in the Value is box.
Ends With (Calculated Field Condition tab only)	LIKE ‘%value’	Ends with the value defined.
(=) 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	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	Is null (contains no value).
does contain data	is not NULL	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.