Use extended comparison operators to perform comparisons on data in SELECT queries. The following outlines the extended comparison operators supported by the SQL engine.
Operator |
Description |
|---|---|
Compares a value to a range formed by two values. |
|
Determines if a value exists in a list of values. |
|
Compares, in part or in whole, one value with another. |
|
Compares a value with an empty, or NULL, value. |
|
Compares a value with a regular expression. |