Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

D toc

Excerpt

Returns true if the first string evaluates to be less than or equal to 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.

D s
snippetBasic

String literal reference example:

D code

derive type:single value:STRINGLESSTHANEQUAL('a','a') as:'stringCompare'

Output: Generates true in the new column stringCompare, since both values are the same.

String literal reference example:

D code

derive type:single value:STRINGLESSTHANEQUAL('a','b') as:'stringCompare'

Output: Generates true in the new column stringCompare, since a evaluates to be less than b.

String literal reference example:

D code

derive type:single value:STRINGLESSTHANEQUAL('abc','x') as:'stringCompare'

Output: Generates true 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:

D code

derive type:single value:STRINGLESSTHANEQUAL(string1,string2) as:'stringCompare'

Output: Generates a new stringCompare column containing the evaluation of string1 column values being greater than string2 column values.

D s
snippetCollation Rules
styleh2

 

Include Page
String Collation Rules
String Collation Rules

D s
snippetSyntax

D code

derive type:single value:STRINGLESSTHANEQUAL(string_ref1,string_ref2)

ArgumentRequired?Data TypeDescription
string_ref1YstringName of first column or first string literal to apply to the function
string_ref2YstringName of second column or second string literal to apply to the function

D s lang notes

string_ref1, string_ref2

String literal, column reference, or expression whose elements you want to compare based on this function.

D s
snippetusage

Required?Data TypeExample Value
YesString literal, column reference, or expression evaluating to a stringmyString1, myString2

D s
snippetExamples

Example - Simple string comparisons

Include Page
EXAMPLE - String Comparison Functions
EXAMPLE - String Comparison Functions

D s also
labelstring