This example demonstrates functions that can be used to compare two sets of strings.
The following table contains some example strings to be compared.
Note that in row #6,
stringB begins with a space character.
For each set of strings, the following functions are applied to generate a new column containing the results of the comparison.
In the following table, the
Notes column has been added manually.
|Evaluation of differences between |
|Comparisons are case-sensitive. Uppercase letters are greater than lowercase letters.|
|Letters later in the alphabet (b) are greater than earlier letters (a).|
|Letters (a) are greater than digits (1).|
|Letters (a) are greater than non-alphanumerics (;).|
Digits (1) are greater than non-alphanumerics (;). Therefore, the following characters are listed in order of evaluation:
|Letters (and any non-breaking character) are greater than space values.|
|The second string is greater, since it contains one additional string at the end.|
|The second string is greater, since its first letter is greater than the first letter of the first string.|