I came across one real time scenario. I have 2 source tables as
'HALKA MUMBAI' 30
'KOLKATA NIGHT' 20
'SUN DELHI RISES' 10
Expected Output : (Join the tables if strings are matching either partially match).
I tried to find one solution approach, but its not working for ('SUN DELHI RISES' = 'DELHI')
Please suggest any generic solution that will work for all cases.
Solved! Go to Solution.
Depends on what is considered a "partial match".
If you only want to check that the string in Table1.Col1 is contained within Table2.Col1, then something like POSITION(Table1.Col1 IN Table2.Col1) > 0 would satisfy your example.