Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 19 Apr 2002 @ 03:11:45 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


Subj:   Re: NULLs and Comparisons
 
From:   Sam Mosley

A null neither matches, nor fails to match, any specified value. Thus, -

WHERE X = :IN_x
>             AND (Y <> :IN_y OR
>                      Z <> :IN_Z)

does not yield a condition of Z <> :IN_Z since it might match. It is unknown. So, it won't be updated.

Sam Mosley



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016