What Does Null Mean?
Null, in a database context, is the total absence of a value in a certain field and means that the field value is unknown. Null is not the same as a zero value for a numerical field, text field or space value. Null implies that a database field value has not been stored.
Techopedia Explains Null
A null cannot be compared to a value. For example, if a query is directed to a Customer_Addresses table to retrieve all customers without email addresses, then the Structured Query Language (SQL) query cannot be written as follows: SELECT * FROM Customer_ Addresses WHERE Email_Address=null. Instead, so as not to introduce a comparison with a null, the query must be written as follows: SELECT * FROM Customer_ Addresses WHERE Email_Address IS null.
