re: Using Full Text Searching SQL Server 2008

Richard Adams — Fri, 13 Jun 2008 01:56:31 GMT

Hi, Thanks for the post. I'm currently looking at using SQL server full text indexing on a new project.. But...

I need to retrieve the actual text where the search terms were found.. I need excerpts from the searched text, highlighting (google style) hit counts, ranking and so forth.. Am I missing something or does SQL server not support this..

I can't see the point of all this technology if all I can get back are rows..

Maybe I need to be looking at Lucene.NET?

Thanks for any pointers..

re: Using Full Text Searching SQL Server 2008

ike — Wed, 06 Aug 2008 17:50:05 GMT

i am using full text search for an application for searching for specific adverts and displaying the details of the advertisers.Am i doing the right thing or i should also be looking at lucene though i am a little biased towards SQL Server.