Comparison CCL Operators
Comparison CCL operators conducts a comparison of TRUE, FALSE, or NULL.
Logical CCL Operators
A Logical CCL operator combines the results of two Boolean expressions or conditions to produce a single result, or inverts the result of a single condition.
Like CCL Operators
LIKE operators are supported by WHERE clause expressions to match WHERE clause string expressions to stings that closely resemble each other.
IN operator
The IN operator asks a set membership question.