||cw

CREATE PROCEDURE [dbo].[sp_X_search]	@searchfor varchar(255)ASSELECT SUBSTRING(text, CHARINDEX(@searchfor, text)-5, 40), nameFROM syscomments, sysobjectsWHERE text LIKE '%' + @searchfor + '%' AND    syscomments.id = sysobjects.idORDER BY name