Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 15 Dec 2008 @ 13:36:38 GMT


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


Subj:   Regarding index function
 
From:   Sridhar Nakka

Hi,

We can use index or position function in teradata to get the position of searching string. But in oracle we can get the second occurrence of the searching string by specifying the parameters like

     SELECT INSTR('Take the first four characters', 'a','1','2') FOUND_1
     FROM dual;

will give 2nd a position that is 23.

As of I see index is useful to get the first occurrence only. So how we can achieve above result by using index or position function in teradata?



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Join Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2014 - All Rights Reserved    
Last Modified: 10 Jun 2014