title: SQL statement to find whole words
body: <p>I have a table with a varchar(max) field, and I need to perform text searches on it. Specifically, I need to find whole words. I have tried </p>
  
  <pre><code>Select * From MyTable 
  Where Col = @SearchTxt
  Or    Col Like @SearchTxt + ' %'
  Or    Col Like '% ' + @SearchTxt + ' %'
  Or    Col Like '% ' + @SearchTxt
  </code></pre>
  
  <p>This works to a certain extent, but it does not give me the instances where the SearchTxt is before or after punctuations (like SearchTxt! or SearchTxt,)</p>
  
  <p>Is there a reasonably easy way to get what I'm looking for, without having a whole bunch of where clauses? Also, the column is not indexed, and although speed is not the primary concern, I want the query to run reasonably fast</p>