"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
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.