title: SQL Server full text search few words at a time
body: <p>I understand that in order to find records that contain more than one word, I need to use AND between them, like this:</p>
  
  <pre><code>select * 
  from table1 
  where contains(name , '"bob" AND "marly"')
  </code></pre>
  
  <p>The problem is that my user doesn't type "bob" AND "marly", he types bob marly.
  Before I start parsing this string and splitting it, is there a cleaner way to do this? </p>
  
  <p>I'm using SQL Server 2012.</p>
  
  <p>Thanks.</p>