title: SQL Server Full Text Search ampersand (&)
body: <p>have problem with ampersand (&amp;)</p>
  
  <p>How to search for the words (or sentences) that contain an ampersand (&amp;).</p>
  
  <p>For example, in the database are:</p>
  
  <pre><code>1: "Johnson &amp; Johnson"
  2: "AT&amp;T"
  3: "Sample &amp; Sample"
  </code></pre>
  
  <p>How should I write a full text search query to search for individual records?</p>
  
  <pre><code>SELECT * from Companies c WHERE CONTAINS(c.CompanyName, '"AT&amp;T"')
  </code></pre>
  
  <p>I know that character (&amp;) is responsible for the logical AND operation. But I do not know how to encode it to search in text with use full text search.</p>
  
  <p>Any idea?</p>