Hans wrote:

> >
> > Just beware that NOT IN handles NULLs differently from NOT EXISTS.
> >
> >
> > Dmitry
> >
> Thank you for the warning. Sometimes I wished that there was
> a setting available per database or per table that elimated all
> NULLs and replaced them by 0 :)
>

There is (sort of) : set a default value on the column, when the table
is created, then it will never contain nulls unless explicitly updated
to null.

regards
ian