Archives of the TeradataForum

Message Posted: Mon, 05 Aug 2013 @ 20:31:39 GMT

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

Not sure if this is what you were asking -the following should return records where values in Col1 are LIKE Col2 or vice versa.

     (INDEX(TRIM(COL1),TRIM(COL2))) > 0 OR  (INDEX(TRIM(COL2),TRIM(COL1))) > 0

Johannes de Wet
Unum

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