Add a simple comparison predicate to an SQL statement

A simple comparison predicate uses logical operators (=, <, >, <>, ...) to compare a column value with another specific value.

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 simple comparison predicate to an SQL statement:

  1. In the Operator list, select a comparison operator (=, <>, <=).
  2. In the Value field, specify a value for comparison. You can:

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