Testing strings for equality counting trailing spaces

The SQL standard requires that string comparisons, effectively, pad the shorter string with space characters. This leads to the surprising result that N” ≠ N’ ‘ (the empty string equals a string of one or more space characters) and more generally any string equals another string if they differ only by trailing spaces. This can…

1