SELECT 
	v.name as vName,
	s.text
FROM 
	sys.views as v
	INNER JOIN sys.syscomments as s ON v.object_id = s.id 
WHERE v.name LIKE '%MY VIEW NAME CONTAINS CRITERIA%'
	AND s.text LIKE '%MY VIEW CODE CONTAINS CRITERIA%'