joining tables based on wildcard code example

Example 1: sql join on wildcard

select *
from tableA a
where exists (select 1 from tableB b where  a.id like '%' + b.id + '%');

Example 2: sql join on wildcard

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