Field expression operators

The operators that are allowed to be used in a field expression are known as the field expression operators. These operators are used to make a comparison between two given values.

Table: Field expression operators lists the descriptions of the available field expression operators.

Table: Field expression operators

Operator	Operator Name	Expression using sample values A, B, and the operator	Description
=	The equality operator	A = B	A must be equal to B
!= or <>	The inequality operator	A!=B	A must not be equal to B
<	The less than operator	A < B	A must be less than B
<=	The less than or equal operator	A <= B	A must be less than or equal to B
>	The greater than operator	A > B	A must be greater than B
>=	The greater than or equal operator	A >= B	A must be greater than or equal to B
Like	The like operator	A Like B	The SQL like operator (same syntax and semantics).
Not Like	The not like operator	A Not Like B	The SQL not like operator. Note the space between not and like. Any amount of white space (blanks, tabs, new lines, or carriage returns) is allowed here. The white space is not strictly required, but it is best not to omit it.
=~	The match operator	A=~B	The regular expression matching operator.
!~	The no match operator.	A!~B	The negative of the expression matching operator.
is null	The is null operator	A is null	The SQL is null operator. A field expression employing this operator must not have a value specified. At least one white-space character is required between is and null.
is not null	The is not null operator	A is not null	The negative of is null. The white space between not and null is not strictly required, but it is best not to omit it.
Exact	The exact operator		Forces case-sensitive string comparison.
Inexact	The inexact operator		Forces case-insensitive string comparison.
%	Contains operator	A%B	In case of a single valued field, value on RHS has to be partially or completely matching with LHS. In case of a multi valued field, every value on RHS has to be present on the LHS.
!%	The Not Contains operator	A!%B	The negative of the Contains operator.
%~	The Contains Match operator	A%~B	In case of a single valued field, the regular expression on RHS should match field value on LHS. In case of a multi valued field, every regular expression on RHS should match at least one element on LHS.
!%~	The Not Contains Match operator	A!%~B	The negative of the Contains Match operator.

See About operators.