Identify text in stored procedure in SQL

SELECT Name FROM sys.procedure WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE %landtype% 
SELECT DISTINCT so.name FROM syscomments sc INNER JOIN sysobjects so ON sc.id=so.id WHERE
 sc.TEXT LIKE '%landtype%'

SELECT * FROM  sys.sysobjects WHERE id in (
select id from sys.syscomments where text like '%landtype%')