A script-enabled browser is required for this page to function properly.

About Query Builder operators

An operator is a character or reserved word that is used to perform some operation. The three principal types of operators used in Query Builder are:

Note: You can also create negating conditions based on these operators.

Comparison operators

Comparison operators are used to compare two values. When you insert the operator between a column name and a value in the Conditions panel, Query Builder will compare all items in that column against the value, and return only those rows where the condition statement is true

For example, to return only those rows where the value in the CREDIT_LIMIT column is less than $6,000, use the < (less than) operator:

CREDIT_LIMIT < 6000

 

Comparison Operator

Usage

=

Equal

<>

Not Equal

<

Less Than

<=

Less Than or Equal To

>

Greater Than

>=

Greater Than or Equal

BETWEEN...AND...

Between two values

IN (LIST)

Equal to any member of the following list

IS NULL

Is a NULL value. A row without a value in one column is said to contain a NULL value.

 

Arithmetic operators

Arithmetic operators are used to perform calculations on numeric and date columns. In handling calculations, Query Builder first evaluates any multiplication or division, then evaluates any addition or subtraction.

To override these precedence rules, place part of the expression in parentheses; Query Builder evaluates expressions in parentheses first.

The Query Builder arithmetic operators are:

Operator

Usage

+

Addition

-

Subtraction

*

Multiplication

/

Division

 

Logical operators

The logical (also called Boolean) operators are AND, OR, and NOT:

The Icon Bar includes icons for the logical operators. The operator icons are available when the Conditions panel is active, or when the Define Column dialog box is open. You can insert an operator into the text of the condition or defined column by clicking the operator in the Icon Bar.

See also

Adding conditions to a query (Query Builder)