eqlin_ci(X;Y)

Returns a boolean value indicating whether the value of the first argument is equal to (one of the values of) the second and is case insensitive. (Available as of version 12.34)

Syntax

eqlin_ci(X;Y)

Input

Argument Type Description
X text A scalar expression or column expression
Y text 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.

Sample Usage

value list eqlin_ci(value;list)
'abcdefg' 'abcDEfg' 1
'abcdefg' 'Abc' 'def' 0
'abc' 'ABC' 'def' 'Hij' 1
'NY' 'Ny' 'Ca' 'Ma' 1
'abc' 0
1