Using Operators to Build the WHERE Clause

This section provides examples for building WHERE Clauses.

Numeric Operators

For any of the numeric operators, select the operator and provide a value.

This example illustrates using the equal operation.

Example Equal Criteria

Between

The Between operator expects an AND keyword in the values field.

This example illustrates using the Between operation

Example Between Criteria

In

In interprets the , (comma) as the separator for the literals.

This example illustrates using the In criteria.

Example In Criteria

Like

Like will implicitly add % (percent sign) with the string.

This example illustrates using the Like operation.

Example Like Criteria