Fulltext Search Problem -- sql server full text search

goku24_dc NO[at]SPAM yahoo.com
9/23/2003 6:27:54 AM

I have a table with book titles. Let's say some of the titles are
"Science", "Journal of Science", "Great Adventures in Science",
"People in Science", and others. When the user searches based on the
keyword "Science", all book title with the word science in them should
be returned. This works, but when I order by rank the rankings are
not being returned as expected. You would think the book with the
title "Science" would be ranked the highest, but this isn't the case.
Does anyone have any idea as to how I could make it so if a title
matches exactly to the keyword searched that it will be ranked the
highest? Is using FullText searching the wrong thing to do in this
case? Any help would be very appreciated.

jt-kane NO[at]SPAM comcast.net
10/1/2003 8:53:47 AM

Hi,
Could you post the full output of the following SQL code?

select @@version

as the SQL Server version and especially the OS platform that it is
installed on is very important in troubleshooting SQL FTS issues.

Also, could you post your exact SQL FTS query? Are you using CONTAINS
or FREETEXT and how many rows in this FT-enable table?

Thanks,
John

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server full text search

sql server full text search : Fulltext Search Problem