Archives of the TeradataForum
Message Posted: Mon, 05 Aug 2013 @ 20:31:39 GMT
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
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|