find a stored procedure in sql server code example

Example: search stored procedures by name

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