CODE EXAMPLE FOR SQL

sql join on wildcard

select *
from tableA a join
     tableB b
     on a.id like '%' + b.id + '%';