find stored procedure in sql server using query code example

Example: search stored procedures by name

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