title: Full text catalog/index search for  %book%
body: <p>I'm trying to wrap my head around how to search for something that appears in the middle of a word / expression - something like searching for "LIKE %book% " - but in SQL Server (2005) full text catalog.</p>
  
  <p>How can I do that? It almost appears as if both <code>CONTAINS</code> and <code>FREETEXT</code> really don't support wildcard at the <strong>beginning</strong> of a search expression - can that really be?</p>
  
  <p>I would have imagined that <code>FREETEXT(*, "book")</code> would find anything with "book" inside, including "rebooked" or something like that. </p>