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 |
|
daniel.newman@bis-web.net
Yak Posting Veteran
71 Posts |
 Posted - 2001-05-24 : 08:57:23
|
| Hello all, I'm trying to perform a freetext search on some varchar fields, with text that the user has input in a text field.I've got the freetext search working (once I'd populated my Full-Text Index -- doh!), but the rank is always being returned as 0. Am I supposed to set something else up to get a relevant ranking?The simple (test) code I created was:SELECT FT_TBL.DisplayText, FT_TBL.Code, KEY_TBL.RANKFROM DocumentText AS FT_TBL INNER JOIN FREETEXTTABLE(DocumentText, DisplayText, 'competition great welcome this') AS KEY_TBL ON FT_TBL.Code = KEY_TBL.[KEY]And this returns two records. One is using three of the above words, and the other only one. Should the ranking reflect this?Thanks for now,Daniel Newman. |
|
|
|
|
|
FreeTextTable not returning a Rank