CREATE PROCEDURE [dbo].[sp_X_search]
	@searchfor varchar(255)
AS

SELECT SUBSTRING(text, CHARINDEX(@searchfor, text)-5, 40), name
FROM syscomments, sysobjects
WHERE text LIKE '%' + @searchfor + '%' AND
    syscomments.id = sysobjects.id
ORDER BY name