Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 11 Oct 2006 @ 13:29:52 GMT


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


Subj:   SQL Replace Function for text
 
From:   Madagani, Rao

Hi All,

We need to find out, if in teradata there is text replace function within SQL.

Ex: Something that will do following (single or multi-character) replacement

     Select "ReplaceFunctionName"('InputString', 'Input', 'Output')

Result:

     'Outputstring'.

     ("ReplaceFunctionName"('InputString', 'search text', 'replace text'))

Or if there is any other way by which we can get the same..

Thanks in Advance.....


Regards,

Rao



     
  <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