The prepared always seem to be luckier

DECLARE @search varchar(100)

SET @search = '%sysobject%'

SELECT

  OBJECT_NAME(id) AS ProcName,

  SUBSTRING(text, PATINDEX(@search, text) - 100, 200)...