Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 30 Jul 2010 @ 13:24:00 GMT


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


Subj:   Re: Deleting unwanted/duplicate records
 
From:   Hill, Karen R

Thank you . . . that did it! The % sign in front of the RT as well is what was needed.

I apologize if it wasn't clear, but I did put in another post that I tried the substr function: "However, as you stated, I'm getting back other values besides the 'RT', which I don't want. What code should be used to select the 'RT' out of the i_ird string? I tried substring(18,2) = 'RT', but that didn't work either." I assumed gave the exact placement of 'RT.'

Again, many thanks and I understand what is happening much better now.


Karen



     
  <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