Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » SQL Language Elements » Search conditions

LIKE search condition Next Page

IN search condition

The syntax for the IN search condition is as follows:

expression [ NOT ] IN { ( subquery ) | ( expression2 ) | ( value-expr, ... ) }

An IN search condition, without the NOT keyword, evaluates according to the following rules:

The NOT keyword interchanges TRUE and FALSE.

The search condition expression IN ( values ) is equivalent to expression = ANY ( values ).

The search condition expression NOT IN ( values ) is equivalent to expression <> ALL ( values ).

The value-expr arguments are expressions that take on a single value, which may be a string, a number, a date, or any other SQL data type.