NULL vs zero vs empty string

Concepts: sqlNullPropagation

Understanding NULL These three concepts are often confused, but they represent completely different things: Purpose of NULL