Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Transact-SQL (2000)  Free text search and combinatorial ranking

Author  Topic  xendig Starting Member 1 Post Posted - 2008-11-20 : 11:32:27 Hi, I have full text enabled on the db and I am trying to come up with a query to search for multiple keywords with the combination having higher rank. For instance, if I have these rows. "Hello USA" "Hello UK" "Travel World" "Hello World" If the user enters two keywords hello, world in the search I would like the 'Hello World' entry to show up first before others. Similarly if I have 3 keywords (a b c), the ranking should be as follows - a AND b AND c - (a AND b) OR (a AND c) OR (b AND c) - a OR b OR c Does SQL server full text indexing support this type of searching capability? Thanks.