How to search/FIND for a text in body of Procedure.

SELECT name
FROM   sys.procedures
WHERE  Object_definition(object_id) LIKE '%TextYouWantToSearch%'

select * from sys.syscomments c

inner join sys.objects o on c.id=o.object_id

inner join sys.schemas s on s.schema_id=o.schema_id

where text like '%dim%'