ACCESS / AQL

or clause

The or clause is used between selection criteria clauses to indicate that either condition being evaluated as true selects the item for processing.

Syntax

with clause or with clause

Example(s)

This example lists those items that meet one of two criteria: a name starting with ar and with a city starting with irv, or, a city starting with san and a contact containing the string joe.

list entity with name "ar]" and with city "irv]" or with city "san]" 
and with contact "[joe]"

See also

Referenced by

7 topics mention or clause in its description.

Index utilization in selection criteria Modifiers Relational operators and logical clauses select command Selection criteria String searching ! logical operator