Filter Expression Operations

Operator

Description

+

Addition.

-

Subtraction.

*

Multiplication.

/

Division.

%

Modulus.

Operator

Description

=

Both arguments are equal.

<>

Arguments are not equal.

>

First argument is greater than other. Applicable only to numeric types.

>=

First argument is greater or equal than other. Applicable only to numeric types.

<

First argument is lesser than other. Applicable only to numeric types.

<=

First argument is lesser or equal than other. Applicable only to numeric types.

Operator

Description

LIKE

First argument sounds like other. Applicable only to strings.

Wildcards: both the * and % can be used interchangeably for wildcards in a LIKE comparison. If the string in a LIKE clause contains a * or %, those characters should be escaped in brackets ([]). If a bracket is in the clause, the bracket characters should be escaped in brackets (for example [[] or []]). A wildcard is allowed at the beginning and end of a pattern, or at the end of a pattern, or at the beginning of a pattern. Wildcards are not allowed in the middle of a string.

IN

First argument can be found in second argument represented as comma-separated list.

Operator

Description

AND

Expression evaluates to True if both of its arguments are True.

OR

Expression evaluates to True if any of its arguments is True.