Are NULL values same as that of zero or a blank space?

[gosai jahnvi]

Are NULL values same as that of zero or a blank space?

[zmbd]

No
While this is in he Access insights, you'll find this an interesting read as this article explains the concepts
home > topics > microsoft access / vba > insights > what is null?

[Abhean]

Typically Null equals Nothing.
"0" is actually a value as is " ". The space is "nbsp" in asci

[AjayGohil]

Hi,

No, A NULL value is not same as zero or a blank space. A NULL value is a value which is 'unavailable, unassigned, unknown or not applicable'. Whereas, zero is a number and blank space is a character.

[Varsha1285]

No blank space and null values are different.Null can be a unknown value or an absence of a value, where as a Blank string is a value, but is just empty.
Null can be used for string , Integer ,date , or any fields in a database where as is used for string fields.
for example there is table Employee-
there are 2 columns EMP_NAME which have a null value so not allocated any memory and EMP_ID have blank space and it has empty value with allocated space in memory. .EMP_NAME column

[Tomas4PawSQL]

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 and effective examination logic to infer the final result of NULL related operations, and the explanation of the applicable conditions and solutions for the four common scenarios in daily development work.
Outline
1. Comparison with NULL Values
2. Case When expression with NULL
3. NOT IN with NULL
4. ALL Subquery with NULL