Impact of NULL Values in SQL Server

Nice article written on NULL values . How to result will change if your column contains NULL value.

https://www.simple-talk.com/sql/t-sql-programming/how-to-get-nulls-horribly-wrong-in-sql-server/