Conditions.bool-primary-comparison

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.


Disclaimer

Geo SCADA Expert 2019