Thats a nice explanation you got !!!

There is also a thing to remember about the ISNULL behavior which is very useful while coding.

Check below link:

http://borngeek.in/understanding-isnulltransact-sql-behavior/