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.


  <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: 23 Jun 2019