Find all tables containing column with specified name - MS SQL Server?

Question

Is it possible to query for table names which contain columns being LIKE '%myName%' ?

Answer 1

select t.name, c.name

from sys.tables t join sys.columns c on t.object_id=c.object_id

where c.name like '%myName%'