Find particular word or text from the entire stored procedure

SELECT distinct(OBJECT_NAME(id)) FROM syscomments WHERE text like '%GetEmployee%'

It will find text "GetEmployee" from the entire stored procedure in the database. Thanks, Imdadhusen