Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 19 Mar 2008 @ 14:58:25 GMT


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


Subj:   Comparing blanks and Nulls
 
From:   Anomy Anom

<-- Anonymously Posted: Wed, 19 Mar 2008 09:53 -->

I want to equate a blank (non-null, non-spaces) value with a Null value so they don't produce results in a minus query.

Any suggestions? I have a translate function but don't think there's an ascii value for Blank ( not x'20' for space).

if I could translate blank to * on one side of the minus, and coalesce Null, * on the other side of the minus, I'd be all set.



     
  <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