Search results

can someone help me with a query that will find similar but not exact values in two tables? the value in T#1 might be like 123, but in T#2 it might be like 123abc or abc123 any help will be greatly appreciated...