Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 09 Jul 2004 @ 20:05:05 GMT


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


Subj:   Cleaning Database Columns
 
From:   Ganga Palakattil

I have a table that has a Varchar(50) column. It gets loaded automatically by a vendor. The column will have numeric and non-numeric data when it gets loaded.

Is there anyway I can set the non-numeric charaters to NULL or delete them using SQL?


Thanks

Ganga Palakattil



     
  <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