= (equality)

The equality operator (=) returns a boolean value indicating whether the value of the first argument is equal to (one of the values of) 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

Y may be a list of values.

Return Value

Returns a boolean value of 1 or 0 indicating whether or not X is equal to (one of the values in) Y.

The data type of the result is integer.

If X and Y are both N/A, the result is 1; if only one is N/A, the result is 0.