search procedure by name code example

Example: search stored procedures by name

select * 
from 
   sys.procedures 
where 
   name like '%name_of_proc%'