Find sp names which contains the given text

Declare @strText varchar(100);
set @strText = '%student%'
Select distinct name from sysobjects SO
inner join syscomments SC on SO.id = SC.id
where SO.type='p' and SC.text like @strText order by SO.name