I am reminded of an old saying:
"Make it possible for programmers to write programs in English, and you will find that programmers cannot write in English."
Care to try that explanation again? Once more, with feeling...
If it's not practically useful, then it's practically useless.
create table #t1 (id int, c1 int)
insert into #t1 select
1, 1 union all select
2, 2 union all select
create table #t2 (id int, c1 varchar(10))
insert into #t2 select
1, '1A' union all select
1, '1B' union all select
2, '8A' union all select
2, '8B' union all select
select * from #t1 a,#t2 b
and b.c1 like convert(varchar(10),a.c1)+'%'
drop table #t1
drop table #t2