Try OpenEdge Now
skip to main content
SQL Reference
SQL Reference : OpenEdge SQL Language Elements : Data types : Relational operators : Quantified Predicate : IN Predicate
 
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.

Syntax

This is the syntax for an IN predicate:
expression [ NOT ] IN
{ (query_expression) | (constant , constant[ , ...] ) }

Example

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