Table A : Address ---------------- 404 First avenue 404 First avenue 404 First avenue Table B: Add1 ---- second 404 231
Address Add1 ------------------------ 404 First avenue 404
select * from A inner join B on a.code=b.code where charindex(B.Add1, A.Address) > 0
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)