all groups > sql server full text search > april 2005 >
You're in the

sql server full text search

group:

Multiple column full text search



Multiple column full text search Xin Chen
4/22/2005 12:00:00 AM
sql server full text search: Is there a way to specify which column weights more when doing full text
search..

For example, I have three column, filename, description and data. I did
full text index on all three column, but want to list the hits in filename
first, is there a way to do it sql 2005?

--Xin Chen

Re: Multiple column full text search Hilary Cotter
4/22/2005 4:40:24 AM
your might want to check out some of these postings for examples of how
to do this.

http://groups-beta.google.com/groups?hl=en&lr=&safe=off&q=SELECT+FT_TBL.au_lname%2C+FT_TBL.au_fname%2C+KEY_TBL.RANK%2C+key_tbl1.Rank&safe=off&qt_s=Search


--
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
AddThis Social Bookmark Button