IN

<field_expr> [ NOT ] IN ( <value_rows> )
( <field_expr_list> ) [ NOT ] IN ( <value_rows> )

The IN and NOT IN operators determine whether or not a given field-expression or list of field-expressions matches any element in a list of values.


Remarks:


Examples

A. Single field-expression

The following example expression determines if the "Age" field matches any value in the specified list: 
Age IN (20; 30; 45; 60)
This example is equivalent to the following expression: 
Age = 20 OR Age = 30 OR Age = 45 OR Age = 60

B. List of field-expressions

The following example expression determines if the pair of "FirstName" and "State" fields matches any pair of values in the specified list: 
(FirstName, State) IN ('Johnson', 'OR'; 'Smith', 'WA')
This example is equivalent to the following expression: 
(FirstName = 'Johnson' AND State = 'OR') OR (FirstName = 'Smith' AND State = 'WA')

See also:

Expressions
Field-Expressions

© 2004 Microsoft Corporation. All rights reserved.

500 Internal Server Error

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator at webmaster@systemmanager.forsenergy.ru to inform them of the time this error occurred, and the actions you performed just before this error.

More information about this error may be available in the server error log.

Additionally, a 500 Internal Server Error error was encountered while trying to use an ErrorDocument to handle the request.