Archives of the TeradataForum
Message Posted: Fri, 29 Jan 2004 @ 20:47:40 GMT
Subj: | | Re: Null values in queries |
|
From: | | McCall, Glenn D |
If you wish to include the NULL's, you have to explicitly request them. As in
where fieldval != 'P' or fieldval is null
As the other responders have mentioned null is something that is unknown.It could be that the fieldval of NULL actually is a 'P' but this
is not know.
Indeed NULL doesn't equal or not equal anything. Any comparison with NULL will always return false (except the "IS NULL" and "IS NOT NULL"
tests).
|