Earlier, I posted blog on T-SQL ISNULL() function. I realized that it is not good idea to post something before sharing knowledge on NULL.
NULL is considered as unknown and result of any expression that include null is also unknown. It is good idea to test null to avoid unknown result. SQL provide IS operator to test null value.
WHERE Expression IS NULL