If you use the Ordinal comparison, you will get the correct result.
The reason is that the comparison of ordinals is done by calculating the numerical value of each of the characters in the string object, so inserting spaces does not matter.
If you use other types of comparisons, there are other things. From the documentation:
An operation using word sorting rules performs a culture-sensitive comparison in which some nonalphanumeric Unicode characters may have special weights assigned to them. Using the rules for sorting words and conventions of a particular culture, a hyphen ("-") can have a very small weight assigned to it, next to the "cooperative" and "cooperative" of each other in a sorted list.
An operation using sorting ordinal orders performs a comparison based on the numeric value (Unicode code point) of each Char per line. The usual comparison is quick, but culture insensitive. when you use ordinal sorting rules to sort strings starting with Unicode characters (U +), the string U + xxxx precedes the string U + yyyy if xxxx is numerically less than yyyy.
Juanr source share