Archives of the TeradataForum

Message Posted: Thu, 12 Mar 2015 @ 18:26:07 GMT

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

Looks like you want to use \b in the pattern (word boundary), e.g. '.*\bissu\b.*'.

Just FYI: you could also use regexp_instr(col2,'\bissu\b',1,1,0,'i') > 0

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