CodeLess Questions query
I have never used it before but I think what you are looking for is CHARINDEX I found a StackOverflow Answer that has several upvotes and no downvotes using it like this

WHERE CHARINDEX('&lt;/code&gt;&lt;/pre&gt;', Body) = 0


So far from what I have seen they are relatively close to the same speed, and is giving the same results as your query.  

I would much rather read this than Body not like '%&lt;/code&gt;&lt;/pre&gt;%'

I think we have found a new "hammer", let's find some nails.

Read more about CHARINDEX Here



There is also a CONTAINS function in T-SQL, but unfortunately it cannot be used on that column of that table because the column is not Full-Text Indexed

Read more about CONTAINS Here