where memo <>'DIS' or memo is null?
or another solution
SELECT col1, col2, col3 where memo <>'DIS'
union
SELECT col1, col2, col3 where memo is null

Regards,
Niki

----- Original Message -----
From: "Matt Clark" <matt.clark@...>
To: "Firebird list" <firebird-support@yahoogroups.com>
Sent: Thursday, October 09, 2003 2:08 PM
Subject: [firebird-support] select null with "field <> 'string' "


> 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
> it?
> I'm on linux with a version of firebird around 1.0.0.
>
> regards,
> mattc
>
>
> Maplin Electronics Ltd.
> www.maplin.co.uk
>
> 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.
>
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>