Using AND and OR on One Column

Restriction: This topic applies to Windows environments only.

You can enter a compound condition containing an AND or an OR in a single cell of the Query Conditions Grid. This condition will be enclosed in parentheses in the SQL statement. For example, you could enter the following condition in the LNAME column of the EMPLOYEE table:

"Hurwood" OR "Kerin"