select
B.ID,
A.ID
from
A inner join B
on
cast(B.ID as varchar(10)) like cast(A.ID as varchar(10))+'%'
order by
B.ID
B.ID,
A.ID
from
A inner join B
on
cast(B.ID as varchar(10)) like cast(A.ID as varchar(10))+'%'
order by
B.ID
on(charindex(A.id,B.id)>0)