Progress
SQL-92
Guide and Reference


IN Predicate

The IN predicate can be used to compare a value with a set of values. If an IN predicate specifies a query expression, then the result table it returns can contain only a single column.

This is the syntax for an in_predicate:

SYNTAX
expression [ NOT ] IN
  { (query_expression) | (constant , constant [ , ... ] )  } 

EXAMPLE

address.state IN (‘MA’, ‘NH’) 


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095