WHERE

States a condition.

Syntax

WHERE expression

Parameters

expression

A logic expression using conditional and Boolean operators.

Comments

WHERE states the conditions that restrict processing in the main command to only certain members of the set specification, contingent on a value within each of the (related) records being considered.

Of all the available (related) records in the record-containing objects, only those records for which the condition is logically true become members of the set.

Example

list all Employees where LastName = Smith and FirstName = J?

The preceding command lists only those employees whose last name is Smith and whose first name starts with the letter J.

 

Related Topics