|
|
Archives of the TeradataForum
Message Posted: Tue, 28 Oct 2003 @ 13:21:11 GMT
Subj: | | Re: Is the following correct ? |
|
From: | | Glen Blood |
Narayan, you asked:
| But what does ANSI standards have to say and what do most databases do in this regard - is what I was looking for when I posted this
question. | |
That is consistent behaviour with the ANSI Standard. The reason is that NULL Is not considered a value. Therefore, you cannot
compare it. Every book that I have read suggests the same solution that David suggested.
Glen
| |