Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 17 Nov 2003 @ 21:46:55 GMT


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


Subj:   Re: Empty Value
 
From:   Frank C. Martinez IV

Try:

select HarryPotterInd, CHAR2HEXINT(HarryPotterInd), count(*)
  from t1
 where HarryPotterInd IS NOT NULL
 group by 1;

If you see something other than "2020" in the second column (uh, that is, if you see 20/20. Nevermind!) that means you've got some sort of OTHER binary data in the field. Betcha just loaded it from the source with doing any fixing. Gotta watch those dem Dementors, they're everywhere.

iv



     
  <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