title: FullText search with CONTAINS on multiple columns and predicate - AND
body: <p>I have a search table with, say, 4 columns of text data to search.</p>
  
  <p>I do something like this:</p>
  
  <pre><code>SELECT * FROM dbo.SearchTable
  WHERE CONTAINS((co1, col2, col3, col4), 'term1 AND term2')
  </code></pre>
  
  <p>It looks like <em>Contains</em> only returns <em>true</em> if term1 and term2 are in the same column. Is there any way to specify that all columns should be included with an AND?</p>
  
  <p>If not, my idea is to JSON all search columns and stick them into one. That way I can full text search them but still easily extract the individual columns in .NET. I'm presuming that the indexer won't have a problem with this and will dispense with the JSON characters and quotes. Is this correct?</p>
  
  <p>Thanks</p>
  
  <p><strong>EDIT</strong></p>
  
  <p>Thinking about the JSON idea, the crawler would also index the property names so I'd have to rename {name}, {details}, {long_details} to something like {x1}, {x2}, {x3} to ensure they'd not be picked in a search. Hopefully if they're so short they wouldn't be indexed anyway.</p>
  
  <p><strong>EDIT2</strong></p>
  
  <p>I can create a <a href="http://technet.microsoft.com/en-us/library/ms142551.aspx" rel="noreferrer">Stoplist</a>, based on the system Stoplist and put the property names into that.</p>