eq_ci(X;Y)

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

Syntax

eq_ci(X;Y)

Input

Argument Type Description
X text A scalar expression or column expression
Y text A scalar expression or column expression

Return Value

Returns a boolean value of 1 or 0 indicating whether or not X is equal to 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

value1 value2 eq_ci(value1;value2)
'abcdefg' 'abcDEfg' 1
'abcdefg' 'Abc' 0
'abc' 'ABC' 1
1
'abc' 0