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.
| Author |
Topic |
|
Ethan
Starting Member
6 Posts |
 Posted - 2007-02-06 : 05:11:46
|
| Hello,In sql server 2k, does anybody know how to retrieve the "score" of the freetext search? Or at least sort by the score/relevancy?It seems like by default it's sorting alphabetically, although the matches seem accurate.Thanks in advance.Ethan |
|
|
Ethan
Starting Member
6 Posts |
Posted - 2007-02-06 : 05:23:55
|
| I think some sample code would help clarify...select first_name, last_name from users where freetext(*, 'joe smith')seems to pull all the joe's out likejoe beenojoe bumbreyjoe corley...joe smith is way down the listIt would be really helpful if the exact match was delivered first.The index is set to search on first_name and last_nameThanks for any help. |
 |
|
|
|
|
|
freetext score... relevancy sort?