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
 SQL Server Development (2000)
 Full text searching

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-10-25 : 08:07:20
Steve writes "I am using a full-text search on a table of text fields, each of which contains up to 100 words. My web application allows the user to enter search terms and view the matching items.

I'm using FREETEXTTABLE with an inner join to the source table.

To save space, I don't want to show the whole of the matched items, just the three or four words either side of the matched words. I would also like to highlight the matched words.

Given the fuzzy matching that's going on, how can I determine which words in the matched item I should display/highlight?"
   

- Advertisement -