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.