title: Use multiple words in FullText Search input string
body: <p>I have basic stored procedure that performs a full text search against 3 columns in a table by passing in a <code>@Keyword</code> parameter. It works fine with one word but falls over when I try pass in more than one word. I'm not sure why. The error says:</p>
  
  <p>Syntax error near 'search item' in the full-text search condition 'this is a search item'</p>
  
  <pre><code>SELECT     S.[SeriesID], 
             S.[Name] as 'SeriesName',
             P.[PackageID],
             P.[Name]     
  FROM       [Series] S
  INNER JOIN [PackageSeries] PS ON S.[SeriesID] = PS.[PackageID]
  INNER JOIN [Package]       P  ON PS.[PackageID] = P.[PackageID]
  WHERE CONTAINS ((S.[Name],S.[Description], S.[Keywords]),@Keywords)
  AND   (S.[IsActive] = 1) AND (P.[IsActive] = 1) 
  ORDER BY [Name] ASC
  </code></pre>