Returns |
Source values can be string literals, column references, or expressions that evaluate to strings.
String literal reference example:
derive type:single value:STRINGGREATERTHANEQUAL('a','a') as:'stringCompare' |
Output: Generates true in the new column stringCompare, since both values are the same.
String literal reference example:
derive type:single value:STRINGGREATERTHANEQUAL('a','b') as:'stringCompare' |
Output: Generates false in the new column stringCompare, since a evaluates to be less than b.
String literal reference example:
derive type:single value:STRINGGREATERTHANEQUAL('abc','x') as:'stringCompare' |
Output: Generates false in the new column stringCompare, since the first letter of the first string is less than the first letter of the second string.
Column reference example:
derive type:single value:STRINGGREATERTHANEQUAL(string1,string2) as:'stringCompare' |
Output: Generates a new stringCompare column containing the evaluation of string1 column values being greater than string2 column values.
derive type:single value:STRINGGREATERTHANEQUAL(string_ref1,string_ref2) |
| Argument | Required? | Data Type | Description |
|---|---|---|---|
| string_ref1 | Y | string | Name of first column or first string literal to apply to the function |
| string_ref2 | Y | string | Name of second column or second string literal to apply to the function |
String literal, column reference, or expression whose elements you want to compare based on this function.
| Required? | Data Type | Example Value |
|---|---|---|
| Yes | String literal, column reference, or expression evaluating to a string | myString1, myString2 |