title: Cannot use a CONTAINS or FREETEXT predicate on table or indexed view it is not full-text indexed
body: <p>I need to fetch all records which contain <code>.</code></p>
  
  <p>At the moment I use this SQL:</p>
  
  <pre><code>  select * from dbo.mytable
      where CONTAINS(Location, '.')
  </code></pre>
  
  <p>but I receive this error:</p>
  
  <pre><code>Cannot use a CONTAINS or FREETEXT predicate on table or indexed view it is not full-text indexed.
  </code></pre>
  
  <p>I cannot set <code>column full text indexed</code> as I do not have high privilege.</p>
  
  <p>Any idea how to circumnavigate this problem?</p>