title: Asp.net fulltext multiple search terms methodology
body: <p>I've got a search box that users can type terms into. I have a table setup with fulltext searching on a string column. Lets say a user types this: "word, office, microsoft" and clicks "search".</p>
  
  <p>Is this the best way to deal with multiple search terms?</p>
  
  <pre><code>(pseudocode)
  foreach (string searchWord in searchTerms){    
      select col1 from myTable where contains(fts_column, ‘searchWord’)
  }
  </code></pre>
  
  <p>Is there a way of including the search terms in the sql and not iterating? I'm trying to reduce the amount of calls to the sql server.</p>