=

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 whitespace
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 casesensitive string comparison.

Inexact

The inexact operator


Forces caseinsensitive 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.
