Re: IS (NULL = 1) equal to NOT(NULL = 1)?

Any test involving a null will be false unless you test using "Is Null" and "Is NOT Null."

Thus in your example (where N is null,)

If N = 1 answer is FALSE.
If N != 1 answer is also FALSE.

An equality test involving a null is meaningless by definition, because null means "no value".

Clear?

Hope it helps,

Louise Miller Received on Wed Aug 21 1996 - 00:00:00 CEST