WHERE clause on SQL Server “Text” data type

SELECT * FROM @Village WHERE [CastleType] like 'foo' 

SELECT * FROM [Village] WHERE PATINDEX('foo', [CastleType]) <> 0