Archives of the TeradataForum

Message Posted: Thu, 04 Dec 2003 @ 10:21:11 GMT

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

Is there any inbuilt function(s) to takecare of INSTR in oracle.

ex : select center_key ,INSTR(TRANSACTION_CODE,'&',1,2)-1) from table a;

rgds

Binoy

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