WHERE

Restriction: This topic applies to Windows environments only.

Used with a SELECT statement to specify search criteria for retrieving rows of data from a table or group of tables. The syntax is:

WHERE search-condition;

The WHERE clause can also be used with DELETE and UPDATE. For example:

WHERE city = "Columbia" OR "Annapolis";

will cause all records that have a city of Columbia or Annapolis to be pulled from the table and exported into the desired target file.