Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 17 Feb 2005 @ 11:18:07 GMT

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

Subj:   Re: Null values in a select
From:   Victor Sokovin

  I got the expected results when I replaced all the nulls with a space. the first query is selecting all the rows from cust_current table as the alter_cust_id has some value in current table and a space in prev table.  

You can use a similar trick in the SQL by using the COALESCE function, the counterpart of Oracle NVL. Even if the table has NULLs, which is sometimes unavoidable, you can "correct" them on the fly. Of course, you need to substitute NULLs by some value which cannot normally occur in the table.



  <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