• I thought it would be 3,3,3,2,2 instead of the correct 3,2,3,2,2. That shows me that I understand NULL pretty well, just not ANSI_NULLS OFF. It's nice to know that it's going away, then. 🙂

    I've saved these queries for when I have to explain how NULL works to other people.