Hi Experts,
I would like to join two tables based on fields of varchar() types
The difference here is that this 'ON' condition will not be a conventional one like this
SELECT * from
TABLE_A as A
inner join TABLE_B as B
on A.Col=B.Col
Instead I want to be a join based on pattern matching
SELECT * from
TABLE_A as A
inner join TABLE_B as B
on A.Col LIKE 'B.Col%'
I count do a substring on one of the columns if it has a consistency across..
But this is not possible...
Does any have any any ideas to use a LIKE pattern matching to join my two tables..
Or any other options to get the same results
Thanks in Advance
Theepan
Start Free Trial
