Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 25 Aug 2016 @ 19:46:12 GMT


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


Subj:   Eliminate rows where data is having any character other than [0-9]
 
From:   Koushik Chandra

Hi,

I have a column in Teradata where actually DECIMAL(10,0) VALUE expected, but as source side sending some time BAD data so we have to set the DATATYPE to VARCHAR(100). In the next step we want to join this column with another table's column which is DECIMAL(10,0) DATATYPE. But this JOIN is failing because of the BAD data. My question is while joining how should we eliminate those rows which are having any character other than [0- 9].


Regards,

Koushik Chandra



     
  <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