Subject select null with "field <> 'string' "
Author Matt Clark
Hello all,
I'm trying to do a select which should pick up all records where a memo
field is not equal to the value 'DIS'. The problem I am finding when I
use "where memo <> 'DIS'" is that a record with memo=<null> is not
returned! This is a problem since null is the default value for this
field and I need to return those records.
Why is null apparently not regarded as <> 'DIS' and what can I do about
I'm on linux with a version of firebird around 1.0.0.


Maplin Electronics Ltd.

This message is intended only for the use of the person(s) ("The intended
recipient(s)") to whom it is addressed. It may contain information which is
privileged and confidential within the meaning of applicable law. If you
are not the intended recipient please contact the sender as soon as possible.
The views expressed in this communication may not necessarily be the views
held by Maplin Electronics Ltd.