How to exactly diiferentiate between a NULL value and a Zero value in a DataBase table? Good Question ! Think lke this……………

Null is like not having a checking account, and Zero is like having a checking account with a zero ballance. Not much of a difference other than conceptual……………………..

This interestingly came in a Book I’m reading these days.

Technically NULL stands for a Data value which is Unknown in SQL.