"Ed Seedhouse" <es********@shaw.ca> wrote in message
news:pa****************************@shaw.ca...
"Randell D." <re**********************@and.share.com> wrote in
message news:<2foIb.871500$pl3.759769@pd7tw3no>...
Folks,
When is it adviseable to create a table column with NOT NULL?
When the nature of the real world data you are modeling is such that
NULL is not a possible value. That is, a situation where a known
value is always available and an unkown value is not possible or
acceptable.
You should allow NULL in any column where "I don't know" is a possible
answer. Remember, NULL is NOT the same as zero. Zero means nothing
or none, which is a definite value.
--
====================================
Thanks for that,
Randell D.