Always an issue of ansi_nulls setting... if run with "set ansi_nulls off", you'll get different output 🙂

As many else wrote, bad choices... both answers are correct... Better with QotD where right/wrong is not up for discussion...:doze:

Hi, I don't agree with you(noticed that others made same comment).

This is a typical ansi setting issue if it will work as explained or not.

Try same query setting...