Ivan,

Thanks for the clarification.

I had based my deductions on the following:
NULL AND TRUE -> ELSE
NULL AND FALSE -> ELSE
NULL OR FALSE -> ELSE
NULL OR TRUE -> THEN

But after reading your posting, I tried the following:
NULL -> ELSE
NOT ( NULL ) -> ELSE

The above confirms that NULL is different from FALSE.

As for the query you suggested, I am convinced to a high degree of its
efficiency, but it was not me who did the original posting; I was just
commenting on the NULL issue.

Regards


_________________________________________________________
Do You Yahoo!?
Get your free @... address at http://mail.yahoo.com