In

Returns TRUE if a value is contained in a specified list of values.

Syntax

Arg1 In Arg2

Where:

Arg2 is a list of the literals with the same data type as Arg1. It can be of the data type numbers, big decimals, text, date/time, or functions that return these data types.

Examples

• Employee@[Last Name] in ("Smith", "Cooper", "Michael")
• Year in (2000, 2001, 2002)