Multiple column full text search

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Xin Chen - 22 Apr 2005 05:33 GMT

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

Reply to this Message

Hilary Cotter - 22 Apr 2005 12:40 GMT

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

Reply to this Message