ACCESS / AQL
AQL relational operators and logical clauses
.mdThis section presents information for each of the AQL relational operators and logical clauses.
These operators and clauses are presented:
In this section
after operator→The after relational operator represents a greater than condition used in constructing selection clauses. The gt and > operators perform the same function.and clause→The and clause is used between selection criteria clauses to indicate that both condition being evaluated as true selects the item for processing.before operator→The before relational operator represents a less than condition used in constructing selection clauses. The < and lt operators perform the same function as before.equal operator→The equal operator represents an equal to condition used in constructing selection clauses. When a valuestring is included, the data found in each item must match it exactly in order for the data to be selected for processing.ge operator→The ge relational operator represents a greater than or equal to condition used in constructing selection clauses.gt operator→The gt operator is a greater than relational operator.le operator→The le operator selects items whose specified attribute name contains a value less than or equal to the specified value string.lt operator→The lt operator selects items whose specified attribute name contains a value less than the specified value string.ne operator→The ne operator selects items whose specified attribute name contains a value not equal to the specified value string.no operator→The no operator reverses selection condition.not operator→The not operator represents a not equal to condition. This reverses the true sense of the condition in a selection criteria. The #, no, and ne operators perform the same function as not.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.