SELECT A.ID -- 객체ID ,A.NAME -- 객체이름 FROM SYSOBJECTS A INNER JOIN SYSCOMMENTS B ON A.ID = B.ID AND ( A.TYPE = 'FN' OR A.TYPE = 'IF' OR A.TYPE = 'P' OR A.TYPE = 'RF' OR A.TYPE = 'TF' OR A.TYPE = 'TR' OR A.TYPE = 'V' OR A.TYPE = 'X' ) AND B.TEXT LIKE '%218.69.93.28%' -- 찾고 싶었던 문자열 GROUP BY A.ID, A.NAME -- 중복제거(TEXT가 4000BYTE 넘으면 여러개 검색되므로) ORDER BY A.ID ASC, A.NAME ASC SELECT * FROM SYSCOMMENTS WHERE text LIKE '%218.69.%'