and

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.