title: Searching a full-text indexed column for pipe characters
body: <p>Consider a column names <code>MyCol</code> with a full-text index. We want to find those rows that have a value of <code>|foo|</code>.</p>
  
  <p>Tried this, but doesn't find those with <em>exactly</em> <code>|foo|</code>:</p>
  
  <pre><code>SELECT * FROM MyTable WHERE CONTAINS(MyCol,'"|foo|"')
  </code></pre>
  
  <p>It returns anything with <code>foo</code>. It seems as if pipes are disregarded as separators.</p>
  
  <p>How can I escape, or otherwise ensure that the exact string <code>|foo|</code> is found?</p>