> Sounds like testing for the existence of a bug.
> X = NULL
> X <= NULL
> X >= NULL
> Etc. must always test false, regardless of the contents of X. Test for
> equality with NULL is a conformance error if NULL == NULL returns true.
They should all return NULL, not false...
> > dates like '00-00-0000');
Yes, that's MySQL's idea of a NULL date. In fact, it's exactly what you
get when you insert a NULL date into a NOT NULL column - hooray the test
proves that MySQL accepts NULL values in NOT NULL columns...
Chris