Add a range comparison (BETWEEN) predicate to an SQL statement

The range comparison (BETWEEN) predicate compares a value with a range of values.

These steps are part of the larger task of adding search conditions to an SQL statement (WHERE or HAVING clause). When you complete the steps for adding a simple comparison predicate to an SQL statement, return to Add search conditions to an SQL statement (WHERE or HAVING clause).

To add a range comparison (BETWEEN) predicate to an SQL statement:

  1. In the Operator list, specify the type of range comparison you want to perform:
  2. In the Minimum value and Maximum value fields, specify a minimum and a maximum value for comparison. You can:

Return to Add search conditions to an SQL statement (WHERE or HAVING clause)