null value


Also found in: Dictionary, Thesaurus, Medical, Legal, Acronyms.

null value

A value in a field or variable that indicates nothing was ever derived and stored in it. For example, in a decimal-based amount field, a null value might be all binary 0s (null characters), but not a decimal 0. The decimal 0 would imply no dollars and cents, which could in fact be a valid derived value. See null and binary.
References in periodicals archive ?
A further example of the effects of null values can be seen below:
The solution for null values isn't always that easy.
Null values, for example, may be accepted in an order reason code field, but only if a specific value appears in an invoice field.
Accommodation of Null Values - Enables mappings of XML files and databases to use default values when sources have absent or null values, but targets must receive content.
In order to be a primary key, a field must meet two conditions: Each record must have a unique identifier in that field, and the field can't hold any blank or null values.