Can Like do this in a SQL query?

I need to find all rows of a table where a field is contained in another table. Table1.Col1 is a 1 character field. Table2.Col2 is a string that will contain one or more characters from Table1.Col1. If three rows in Table1 contain “A”, “B”, and “C”,and one row in Table2 contains “AC”, I would want to return the 1st and 3rd rows from Table1.

How do I do this?