How to make join on like?

Question

Transact SQL

There are 2 tables, one has an ID column with the code 576000, the other table also has an ID with the code as in the screenshot, the central part is completely identical, is it possible to make a join? or not? How then to connect according to this criterion?
according to this criterion

Answer 1

SELECT Table_A.ID1, Table_B.ID2
  FROM Table_A INNER JOIN Table_B ON CHARINDEX(Table_A.ID1, Table_B.ID2) > 0

If you need a template, use PATINDEX.

Answer 2

is it possible to do a join?

Can. JOIN ON LIKE is a perfectly valid construct. Brake only.

Answer 3

Too vague TK. The simplest like '%576000%'
You can also use wildcards