Returns the result of a comparison operation
Format
expression comparison-operator
{ expression
|
{ ALL | SOME | ANY } ( { query-expr
| expr-list } ) }
Remarks
The following table describes each type of comparison-operator:
| Type | Description |
|---|---|
| = | Equal |
| < | Less than |
| <= | Less than or equal to |
| > | Greater than |
| >= | Greater than or equal to |
| <> | Not equal to |
The comparison operator always returns Unknown if either the left or right value being compared is NULL.
The keywords SOME and ANY are interchangable.
For further information about the above operators and the data types that are supported, see Operators and see Operands and Resulting Data Types.