title: SQL Server Full-Text-Search FREETEXTTABLE search multiple columns
body: <p>I'm using the below query to return results from a table using Full-Text-Search.
  In SQL2000 it was only possible to search one or all columns in a table. Is it possible in SQL 2008?</p>
  
  <p>I would like to search two tables, Problem and Solution (Both indexed and in the same table):</p>
  
  <pre><code>DECLARE @topRank int set @topRank=(SELECT MAX(RANK) 
  FROM FREETEXTTABLE([Support_Calls], Problem, 'test', 1)) 
  SELECT [ID] AS [Call No],Company_Name, Problem, Solution, CONVERT(VARCHAR(20),CAST((CAST(ftt.RANK as DECIMAL)/@topRank * 100) AS DECIMAL(13,0))) + '%' as Match 
  FROM [Support_Calls] INNER JOIN FREETEXTTABLE([Support_Calls], Problem, 'test') as ftt ON ftt.[KEY]=[ID] ORDER BY ftt.RANK DESC;
  </code></pre>
  
  <p>From what I can see the FREETEXTTABLE does not accept more than one column?</p>