sql server full text search: Ben,
Could you post the full output of -- SELECT @@version -- as this would be
most helpful in understanding your FTS question based upon the subject
"search in multiple columns" of this posting.

Assuming you're using SQL Server 2000 and want to search across or in
multiple columns either in one table or from multiple table, you may want to
checkout my blog entry on this subject - "SQL Server FTS across multiple
tables or columns" at:
http://spaces.msn.com/members/jtkane/Blog/cns!1pWDBCiDX1uvH5ATJmNCVLPQ!316.entry

If you provide more information, I can provide you with more specific
examples.

Thanks,
John
--
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/



[quoted text, click to view]

this seems to be an incomplete post

With SQL 2005 you can specify which columns you wish to search. With SQL
2000 you can specify 1 column or all columns (*), or you could do an or
query

Select *From TableName where contains(Col1, 'SeachPhrase') or contains(Col2,
'SeachPhrase') or contains(Col3, 'SeachPhrase') ....

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

[quoted text, click to view]

hello

The situation is the following: I have table names "authors" with the
columnes

--