Sql query with wild cards

Hi All,

I have two tables: Table1 and Table2. I want to retrieve records from Table1 that match a specific pattern in a column based on data from Table2.

Thanks in Advance.