Hi,
I have fulltext indexed several columns in a table, how do I search two or more columns but not all the columns?

you have to do something like select * from tablename where contains(Col1, '
"SearchPhrase" ') or contains(Col2, ' "SearchPhrase" ')

You would be better off to have a child table with only the columns you want
to query and to index that child table. Part this table in a different
catalog to take advantage of the thread limit per catalog.


[quoted text, click to view]

Hi,
Thanks for the tip.