title: My ContainsTable query is not working - please help :)
body: <p>I've got a full text catalogue setup. It has a unique key count of 117 with 19 items. The table has 19 rows only. </p>
  
  <p>The table has an NVARCHAR(50) field called ClientGuid. It's a guid with some weird text at the end.</p>
  
  <p>eg.. </p>
  
  <ol>
  <li>8b6ef4a504dd1a57f079180e7f6eb4a0(-)</li>
  <li>8b6ef4a504dd1a57f079180e7f6eb4a0(OK)</li>
  </ol>
  
  <p>(and no, i didn't defined that text field data - we're sourcing it from a 3rd party API.</p>
  
  <p>anways, this is my sql and the query i run against it. When i run the query, i get ZERO results back :(</p>
  
  <pre><code>ALTER FUNCTION [dbo].[Foo_HiJonSkeet]
  (   
      @ClientGuid NVARCHAR(50)
  )
  RETURNS TABLE 
  AS
  RETURN 
  (
      SELECT KEY_TBL.[Key] as LogEntryId,
          KEY_TBL.RANK as Relevance
      FROM CONTAINSTABLE(LogEntries, ClientGuid, @ClientGuid) AS KEY_TBL
  )
  
  
  SELECT * FROM  Foo_HiJonSkeet('8b')
  </code></pre>
  
  <p>Any suggestions?
  Server is Sql Server 2008.</p>