Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 08 Jul 2005 @ 18:22:55 GMT


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


Subj:   Filtering the Junk values from a field
 
From:   kumar28

Hi,

I have a column in a table that contains alpha numeric characters(something like: 0154A258D). But there are few records in this field that are junk (something like: =7F =E5,=7F =F4, =7F=0E ,=7F=FD =,=7F=FD=0F ,=7F=FD=1F =06,=E9w!=7F=FD) and there a lots of them like this.

Valid data for this field can only contain combination of values from A to Z and 0 to 9. I am trying to select only the valid values and ignore the junk. Is there a way to select only the valid values....


Thanks

Raj



     
  <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