lt_ci(X;Y)
Returns a boolean value indicating whether the value of the first argument is less than the value of the second argument and is case insensitive. (Available as of version 12.34)
Syntax
lt_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 less than Y.
The data type of the result is integer.
If X is N/A, the result is 1; otherwise, if
Y is N/A the result is 0. (N/A is treated as if it were
less than any other value.)
Sample Usage
value1 |
value2 |
lt_ci(value1;value2) |
|---|---|---|
| 'abcdefg' | 'abcDEfg' | 0 |
| 'Abc' | 'abcDEfg' | 1 |
| 'abc' | 'def' | 1 |
| 0 | ||
| 'abc' | 1 |