One of the more prominent MVPs - while he failed to react to this thread - has provided a comprehensive article relating to ISNULL and COALESCE: http://sqlmag.com/t-sql/coalesce-vs-isnull. After reading it, I am ready to use ISNULL again but this time knowing what I am doing and why.