12,251,889 members (58,805 online)
Rate this:
See more:
Hi there,

What is the main difference between Null and Not Null.

Thanks,
Enos
Posted 11-Jul-12 4:20am

Rate this:

## Solution 1

Null is an absence of a value, so Not Null is the absence of the absence of a value.

I.e. if there is no value, it it Null.
If there is any value, it is Not Null.

Null should not be confused with zero, or naught, as that is a value. Null is a special condition which is outside the range of values of any item. For example, if you remove 1, 2 and 3 from the set {1, 2, 3} you get the empty or null set {}. If you remove 1, 2 and 3 from the set {0, 1, 2, 3} you do not - you get a set with a single element in it: {0}

Typos: "teh" for "the", "absnce" for "absence" - OriginalGriff[/edit]
v2

Top Experts
Last 24hrsThis month
 OriginalGriff 662 ppolymorphe 399 Sergey Alexandrovich Kryukov 306 CHill60 300 Dave Kreskowiak 279
 OriginalGriff 1,803 ppolymorphe 1,151 CHill60 1,100 George Jonsson 1,095 Dave Kreskowiak 827