When NULLs need to be considered, we've always been forced to include this additional IS NULL or IS NOT NULL syntax. This not only clutters T-SQL code, but forces the execution plan to use an index ...