mssql 컬럼 검색, 문자열 찾기

-- 컬럼 검색 
SELECT DISTINCT
       T.NAME AS TABLE_NAME
   FROM SYS.TABLES AS T
  INNER JOIN SYS.COLUMNS AS C
     ON T.OBJECT_ID = C.OBJECT_ID
  WHERE C.NAME LIKE '%부서%'

--문자열 찾기 
SELECT DISTINCT OBJECT_NAME(ID)
FROM SYS.SYSCOMMENTS
WHERE TEXT LIKE '%내가찾을문자열%'