How do I find a stored procedure containing ?

SELECT *
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%text%'
AND ROUTINE_TYPE='PROCEDURE'

 

SELECT Name
FROM sys.procedures
WHERE OBJECT_DEFINITION(object_id) LIKE '%text%'

SELECT  *
FROM sys.sql_modules
WHERE Definition LIKE '%text%'
AND OBJECTPROPERTY(object_id, 'IsProcedure') = 1