gt_ci(X;Y)

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

Syntax

gt_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 greater than Y.

The data type of the result is integer.

If X is N/A, the result is 0; otherwise, if Y is N/A the result is 1. (N/A is treated as if it were less than any other value.)

Sample Usage

value1 value2 gt_ci(value1;value2)
'abcdefg' 'abcDEfg' 0
'Abcdef' 'abc' 1
'def' 'abc' 1
0
'abc' 1