IN

Description

Evaluates to True if the value returned by <expression> is included in <value> as an element at any point. <expression> can be <table>.<column> or AGG(<table>.<column>, <start>, <end>).

Example

LOAN.STATUS IN ('A', 'C')