Search inside stored procedures

select *
FROM   INFORMATION_SCHEMA.ROUTINES
WHERE  OBJECTPROPERTY(OBJECT_ID(SPECIFIC_NAME),'IsMSShipped') =0
       and OBJECT_DEFINITION(OBJECT_ID(SPECIFIC_NAME)) like '%search term here%'
       AND ROUTINE_TYPE='PROCEDURE'