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 |