Could we have the question expanded to include a comment that ANSI_NULLS is set to ON?  Because if a user ran that with ANSI_NULLS OFF, the WHERE clause would evaluate to TRUE.