ACCESS / AQL

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.

Synonymseqis=

Syntax

with {not} attr.name equal "valuestring"

Example(s)

list jobs with user equal "dm"

list jobs with user = "dm"

Note: When using an ADI with an mt processing code, a null value is converted to zero before testing for equality or inequality. Therefore, ADI = “” will find nothing and ADI # “” will return everything. This only affects “equal” or “not equal”. “Less than or equal”, “Greater than or equal” and others are not affected.

Referenced by

7 topics mention equal operator in its description.

Index utilization in selection criteria Modifiers Relational operators and logical clauses Throwaway connectives = assignment operator eq assignment operator is command