Select ... WHERE LIKE (%Column Name%) 1

[perfectchaoss]

Hi,
I have a query that I want to run that has two tables. The 1st table has an Identifier that is alwaya 13 digits long. The 2nd table contains the same ID's except sometimes they are incomplete. Even though the 2nd table is not 13 digits, they are unique and match up to a unique record on the first table. I want to query all the items in the first table that are in the second table.

table 1: Table 2:
ID: 000111222330 ID: 1112223

basically i want to
Select 1stTableID WHERE it is LIKE '%2ndTableID%'.

Thanks in advance
JF

 

[swampBoogie]

Select t1.TableID from t1,t2
WHERE t1.tableid LIKE '%' + t2.TableID + '%'

 

[perfectchaoss]

SwampBoogie,
Thanks for the quick response
JF