• Excellent trick question.

    String comparison for both char & varchar ignores trailing spaces - even when ANSI_PADDING is ON.