在存储过程中查询某个关键字

SELECT DISTINCT 'sp_helptext ' + c.name AS SP_Name 
      FROM sysobjects c 
LEFT JOIN syscomments g ON c.id = g.id 
WHERE c.xtype IN('p') AND g.[text] LIKE '%票台%' 
ORDER BY 1