hello
The situation is the following: I have table names "authors" with the
columnes
Hilary Cotter - 22 Feb 2005 15:18 GMT
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') ....

Signature
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
> hello
>
> The situation is the following: I have table names "authors" with the
> columnes
John Kane - 22 Feb 2005 16:11 GMT
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

Signature
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
> hello
>
> The situation is the following: I have table names "authors" with the
> columnes