Archives of the TeradataForum

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

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

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>>