No, A NULL value is not the same as zero or a blank space.

NULL value processing is the most error-prone for database application developers, mainly because we are accustomed to using binary Boolean logic to think, while the database's processing logic for NULL values is three-valued logic.

You can refer to Four Pitfalls of SQL Processing with NULL Values to find out the root causes of the NULL value pitfalls, a simple...