MSSQL Full text search question

[Skywick]

Hi

I am trying to do a full text search with a column name for the search term.
I can do this using LIKE with:

SELECT tblContent.ID FROM tblContent INNER JOIN #keywords ON  tblContent.words LIKE '%' + #keywords.keyword + '%'

But I can not seem to do this using the CONTAINS syntax.
eg.

SELECT tblContent.ID FROM tblContent, #keywords WHERE CONTAINS(words,#keywords.keyword)

The reason I am trying to do this is because my final search result must contain all the words in the search phrase, even if they are not next to each other. (The search involves fields across multiple tables.) To achieve this I have split the search phrase into a temporary table. Then once all the possible tables/columns have been searched and appended to another temporary table I can remove the results that have not scored for all the words in the search phrase. I was trying to speed the process up with full text search.

I also thought there might be a way of doing this using CONTAINSTABLE rank, but I can not see how.

Any help would be much appreciated.