Archives of the TeradataForum
Message Posted: Thu, 29 Jan 2004 @ 10:30:36 GMT
| Subj: || || Re: Null values in queries |
| From: || || Narayan Murthy |
Yes, If you see the explain of your query , you will find the elimination of NULL. The behaviour is correct, 'cause you asked for a fieldval
!='P' which means you have asked to retrieve rows which do not contain the value 'P', so all the knowns are returned and the unknowns(Null)
eliminated. The blank is considered 'cause it again is a known it is something which can be defined.