Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 04 Dec 2009 @ 14:39:47 GMT


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


Subj:   Find and replace substring
 
From:   GRAHAM, Paul

Hi

I am having difficulty finding how to replace the 'replace' function we have been using in Oracle with equivalent functionality in Teradata. I have searched web forums/teradata sites and haven't been able to find anything which fits our needs (I know Teradata doesn't have a 'replace' function).

We need to remove double occurrences of any letter from our data. This is so our data matching software runs more smoothly.

For example, we want to replace '%AA%' with '%A%' (changing Isaac to Isac and Aaron to Aron etc), from 'A' through to 'Z'

A solution or pointing in the right direction would be highly appreciated!


Paul Graham



     
  <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