Archives of the TeradataForum

Message Posted: Thu, 04 Dec 2003 @ 10:58:33 GMT

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

Hi Binoy,

Try using this , this should return the position of second occurence of '&' in transaction_code.

index(substr(transaction_code,index(transaction_code,'&') +1) ,'&') + index(transaction_code,'&')

Regards,

Rachana

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