Alan McDonald wrote:

> I'll raise again another issue once more and re-state how we doggedly argue
> around the NULL equivalence issue here and ask again - hasn't anyone noticed
> that it's a very often expressed confusion as to why newbies can't test for
> something being equal to NULL? We keep arguing the point with them about
> NULL's a state not a value.. yeh yeh - so what!

Don't see the problem
WHERE field IS NULL OR field = 0

Once people understand THAT then NULL is not a problem.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services