I always think of NULL as similar to "I have no idea if this has a value
or if it does what value it is." This situation makes comparisons
impossible. The two values are neither equal nor not equal.
Also note that blank and empty are not null values, they are zero length
strings or the equivalent in numbers.
I just don't worry about it and check for null values when needed.
IF vX <> columnvalue or vX IS NULL or columnvalue IS NULL then
<handle it here>
ENDIF
Albert
Marc wrote:
This always reminds me of Who's on First, it makes your head spin.
But to my way of thinking and what I think would make sense to users
Hello is only = to Hello therefore <> to anything else
so with EQNULL ON or OFF the Pause statement should fire because
no matter what Hello can not be = to a blank field or a null or empty
field
Hello can only be = to Hello
The same for <> Hello is = to only Hello therefore <> to everything else.
Am I nuts or just not getting this. Maybe my RBrain is set Off?
Marc
