title: Using Full-Text-Search in order to find partial words (SQL Server 2008)
body: <p>I'm trying to build a facebook like search for my software.</p>
  
  <p>I'd like to query the table customers.</p>
  
  <p>I've set up a FULLTEXT Index and tried the next query</p>
  
  <pre><code>SELECT * FROM Customer where CONTAINS(*,'*ann*')
  </code></pre>
  
  <p>The query does return all the customers named Ann, but it doesn't return all the customers name Anne.</p>
  
  <p>Is there a way to create prefix search on SQL Server 2008 using FTS?</p>