Selecting From a List of Values

You can use the IN predicate to check for a records having values that match a member of a list of values. For example, you could type the following into a cell of the EMPLOYEE table's ST column:

IN ('MD', 'VA', 'DC', 'NY')