Archives of the TeradataForum
Message Posted: Fri, 29 Jan 2004 @ 20:47:40 GMT
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).
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|