SQL operators

This list includes operators currently supported by Network Reporting.

and

Logical operator; conjunction.

expression AND expression

between

Test expressions for inclusion in a range of values, using the keywords BETWEEN and AND.

BETWEEN expression AND expression

exists

The argument of EXISTS is an arbitrary SELECT statement, or subquery. The subquery is evaluated to determine whether it returns any rows. If it returns at least one row, the result of EXISTS is True; if the subquery returns no rows, the result of EXISTS is False.

[ NOT ] EXISTS (table_subquery)

explode

Performs an aggregate function on groupings of numbered fields (for example,

specialty_1__v
,
specialty_2__v
, through
specialty_10__v
).

For more information, see Groups of fields.

ilike

Performs a case-insensitive pattern match for single-byte or multibyte characters.

expression [NOT] ILIKE pattern

in

IN: True if the expression on the left is found in the expression list or subquery. NOT IN: True if the expression on the left is not found in the expression list or subquery.

expression [NOT] IN (expression_list | table_subquery)

is

Logical operator; logical assertion.

expression IS [NOT] value

like

LIKE performs a case-sensitive pattern match for single-byte characters. Compares a string expression with a pattern that can use wildcard characters.

expression [NOT] LIKE pattern

or

Logical operator; disjunction.

OR