MS SQL query for searching in column names

Search column names for keywords using "like"

SELECT name FROM sysobjects
WHERE id IN (
SELECT id FROM syscolumns WHERE name like '%KEYWORD%' )