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 are based on the Query Builder field type conventions. See 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 field.
Contains	LIKE ‘%value%’	Contains the string defined in the Value Is field.
Ends With (Calculated Field Condition tab only)	LIKE ‘%value’	Ends with the value defined.
(=) equal to	=	Equals the value defined in the Value Is field.
(<>) not equal to	!= <>	Is not equal to the value defined in the Value Is field.
(<) less than	<	Is less than the value defined in the Value Is field.
(<=) less than or equal to	<=	Is less than or equal to the value defined in the Value Is field.
(>) greater than	>	Is greater than the value defined in the Value Is field.
(>=) greater than or equal to	>=	Is greater than or equal to the value defined in the Value Is field.
In	in	Contains one of the strings defined in the Value Is field, such as an embedded literal OR statement. You must use quotation marks around any values to indicate what it must search.
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.