I think that having this topic defined and available
will be of great benefit... !!! Thanks Richard.
Some additional thoughts based upon what other people
have explicitly or implicitly implied. Peter quoted the sql
definition as:
>Every data type includes a special value, called the null valu
Another viewpoint, is to go a bit further into implementation...
i.e. for every field, there are two items...
*one item being the null/notnull info
*other item being the value info of the field per the type at def time
This faciliatates the concepts of
where is null ... testing the null/notnull in
Just 'cuz you can do something with a language feature does not
necessarily mean that it is a good way to do it. If this is a
common query and you have a large dataset, then this is going to
be computationally intensive.
Why not create a field as part of the table and create a trigger
to update
