It is always good to refresh your memory on the proper use of NULL in SQL. This article from SQLServerCentral.Com, written by Michael Coles (author of Pro T-SQL Programmer's Guide), is concise, well-written and packed with good info.
"Whenever you find a man who says he doesn't believe in a real Right and Wrong, you will find the same man going back on this a moment later." - C.S. Lewis, The Case for Christianity