Determines whether a selected value matches any value in a given collection of values.
Syntax:
IN(match value, value1, value2)
Parameters:
match value – The value that is matched with one of the other values.
values – Each parameter represents a value to be matched with the match value parameter.
Returns:
True when the match value is matched with one of the other values. False is returned when the match value cannot be matched.
Examples:
IN('cat','bird','cat','dog') returns True.
IN('Java','UNIX','Microsoft','Web Service') returns False.
IN(5,1,2,3,5) returns True
If A is 01/01/2003,IN(A,'01/01/2003'd,'03/04/03'd) returns True
Note:
Using the IN function in the Magic Where Clause property will be automatically translated to the expected syntax of the underlying DBMS.
Platform specific:
For IBM i platforms, this function is available from iSeries OS/400 V5R2.
See also:
The Online and Rich Client Samples projects (program BS03 and RBS03)
