My data looks like as shown below. I need to be able to join the 2 tables (table a and table B) like Select column A from tableA T1 join tableB T2 where T1 columnA like T2.columnB
So column A in table A can match up to any value in column B in table B irrespective of string length . How do I do that ?
