title: How to do a CONTAINS() on two columns of Full Text Index Search SQL
body: <p>I have a table (MyTable) with the following columns:</p>
  
  <p>Col1: NameID VARCHAR(50) PRIMARY KEY NOT NULL
  Col2: Address VARCHAR(255)</p>
  
  <p>Data Example:</p>
  
  <p>Name: '1 24'
  Address: '1234 Main St.'</p>
  
  <p>and i did a full text index on the table after making the catalog using default params.</p>
  
  <p>How can I achieve the following query:</p>
  
  <pre><code> SELECT * FROM MyTable
   WHERE CONTAINS(NameID, '1')
   AND CONTAINS(Address, 'Main St.');
  </code></pre>
  
  <p>But my query is returning no results, which doesn't make sense because this does work:</p>
  
  <pre><code> SELECT * FROM MyTable
  WHERE CONTAINS(Address, 'Main St.');
  </code></pre>
  
  <p>and so does this:</p>
  
  <pre><code> SELECT * FROM MyTable
   WHERE CONTAINS(Address, 'Main St.')
   AND NameID LIKE '1%'
  </code></pre>
  
  <p>but this also doesn't work:</p>
  
  <pre><code> SELECT * FROM MyTable
   WHERE CONTAINS(NameID, '1');
  </code></pre>
  
  <p>Why can't I query on the indexed, primary key column (Name) when I selected this column to be included with
  the Address column when setting up the Full Text Index?</p>
  
  <p>Thanks in advance!</p>