View Source

Returns true if the first string evaluates to be greater than the second string, based on a set of common collation rules.

Source values can be string literals, column references, or expressions that evaluate to strings.

String literal reference example:

stringgreaterthan('a','b')

Output: Returns false since a evaluates to be less than b.

String literal reference example:

stringgreaterthan('a','ab')

Output: Returns false since the second string contains an additional letter.

String literal reference example:

stringgreaterthan('abc','x')

Output: Returns false since the first letter of the first string is less than the first letter of the second string.

Column reference example:

stringgreaterthan(string1,string2)

Output: Returns the evaluation of string1 column values being greater than string2 column values.

stringgreaterthan(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`