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, -

>             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: 15 Jun 2023