title: Full text search in sql server
body: <p>I am using SQL Server 2008. I have indexed the <code>ProductName</code> column in the <code>Product</code> table as full text search index. Some <code>ProductName</code> values as examples:</p>
  
  <pre><code>ProductName
  -------------
  Iphone 3GS
  Iphone 4S
  Iphone 5S
  Iphone 5
  </code></pre>
  
  <p>Now I am using the following code to search for <code>Product</code>:</p>
  
  <pre><code>WHERE CONTAINS (Product.ProductName, '"Iphone 4S"')
  </code></pre>
  
  <p>It's OK! But if I edit and use this:</p>
  
  <pre><code>WHERE CONTAINS (Product.ProductName, '"4S Iphone"')
  </code></pre>
  
  <p>No results!</p>
  
  <p>Could you help me to solve this problem? Thanks.</p>