Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sun, 29 Jul 2002 @ 00:49:17 GMT


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


Subj:   Re: Solution to Teradata String Replace within a string Function
 
From:   Michael Larkins

Hi Dieter:

Hope all is well with you.

Your run failed because there was only one "-" in it. As stated in my original posting, it is for replacing strings with 2 "-" signs in them. So, if you were to change your row to some thing like "one-minus-", it would work correctly.

If you have a mix of characters, then you need to add a WHERE clause that only attempts changing the ones with two of the characters in it.


Hope this help clear up the confusion.

Mike



     
  <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: 15 Jun 2023