title: Best way to literal phrase search a text column in SQL Server
body: <p>I thought full-text search would let me do exact phrase searching in a more optimized way than a LIKE predicate, but I'm reading that it doesn't do that exactly.</p>
  
  <p>Is "LIKE" the most efficient way to search thousands of rows of TEXT fields in a table for a literal string?</p>
  
  <p>It's got to be exact matching...</p>