Previous PageNext Page

Allowable expressions in the WHERE statement

Other useful forms:
Use the IN operator to check whether a variable's value is equal to one of a list
WHERE Gender IN ('M', 'F');

Two other "forms" are legal in a WHERE statement:
The BETWEEN-AND operator:
WHERE Weight BETWEEN 100 AND 200;

The CONTAINS operator:
WHERE diagnose CONTAINS 'depres';

See C&P Chapter 3, WHERE statement operators

Previous PageTable Of ContentsNext Page