Find Text in Store Procedure

SELECT *
FROM sysobjects so
WHERE so.id IN (
   SELECT id
   FROM syscomments
   WHERE [text] LIKE '%abc%'
)
AND [type] = 'P'