Find procedure or function in SQL Server 2008

If you have lots of functions or procedure and you forgot the name, you can use the following query to find by name

SELECT DISTINCT o.name ,o.xtype
FROM syscomments c
INNER JOIN sysobjects o ON c.id=o.id
WHERE c.TEXT LIKE '%SOME_TEXT%'
GO

Thanks