sql server - A simple sql code request, check it out please -

i need simple sql code following-:
in table1, got column codename , varchar(128), in table2, got column codename there little difference between contents in these columns.
in table1, codename : item_pinnacle_w_clothes_10_aa_c_crusader
in table2, codename : item_10_crusader_ch_w_clothes
is there possible way write query : table1 tbl
join table2 tbl2
on tbl.codename part tbl2.codename

i'd appreciate help. =)

column name doesn't matter, make sure column has same data type.

from sqlfiddle, can see last query failed, since trying make join between 2 different data type. so, far data type same. can join.

sqlfiddle demo

so answer yes.