<> (inequality)
The inequality operator (<>) returns a
boolean value indicating whether the value of the first argument is not equal to (any of the
values in) the second.
Syntax
X<>Y
Input
| Argument | Type | Description |
|---|---|---|
X |
any simple type | A scalar expression or column expression |
Y |
any simple type | A scalar expression or column expression
|
Return Value
Returns a boolean value of 1 or 0 indicating whether or
not X is not equal to (any of the values in) Y.
The data type of the result is integer.
If X and Y are both N/A, the result is
0; if only one is N/A, the result is 1.