Type
Logical Operator

Purpose
The and operator combines two or more sets of selection criteria.

Syntax
SELECTION CRITERIA 1 and SELECTION CRITERIA 2 [and SELECTION CRITERIA 3 . . .]

Returns
The values in records that satisfy all of the selection criteria statements.
Usage
The and operator requires that a record meet all the specified selection criteria to be processed. The or operator requires that a record meet any of the specified criteria to be processed. When selection criteria are combined with both the and and or operators in one statement, the criteria must be enclosed in parentheses to clarify the meaning.

Example 1
for MEMBERS with STATE = "NY"
and TOTAL DUE > 500
and LAST NAME between "A*" to "L*" ;

This statement tells DataEase to process only those MEMBERS records that contain NY in the STATE field, a value greater than 500 in the TOTAL DUE field, and a LAST NAME value that begins with any letter between A and L (inclusive). Only records that satisfy all three criteria are processed.

Example 2
for MEMBERS with ( STATE = "NY" or STATE = "NJ" )
and TOTAL DUE > 500 ;

This statement tells DataEase to process only those MEMBERS records that contain either NY or NJ in the STATE field and a value greater than 500 in the TOTAL DUE field.

Example 3
for MEMBERS with STATE not = "NY" and STATE not = "NJ" ;

This statement tells DataEase to process all the members records except those that contain either NY or NJ in the STATE field.
Again, only records that satisfy all sets of criteria are processed.