Highlight Keywords

I am using asp.net (C#) to create full text searching using SQL Server
2005 in our application. Everything is working fine, but I am trying
to highlight the resultset keywords from the full text results. Can
sql server provide you with a way to highlight the keywords from the
full text search?
I was able to kind of hack it by programatically replacing my keyword
search terms with the sql server resultset. However, when I do certain
searches, like "Frank's", sql server will return Frank using my
CONTAINS query, and I want the other results like "Frank" to be
highlighted too. Anyone know a good way to go about doing this?
Thanks
You have to implement your own version of Porter stemmer algorithm for this.
You can use Indexing Services for this, here is a link describing how to do
this.
http://www.indexserverfaq.com/sqlhithighlighting.htm
"guate911" <guatemala911@.gmail.com> wrote in message
news:1179417689.771131.84700@.k79g2000hse.googlegro ups.com...
>I am using asp.net (C#) to create full text searching using SQL Server
> 2005 in our application. Everything is working fine, but I am trying
> to highlight the resultset keywords from the full text results. Can
> sql server provide you with a way to highlight the keywords from the
> full text search?
> I was able to kind of hack it by programatically replacing my keyword
> search terms with the sql server resultset. However, when I do certain
> searches, like "Frank's", sql server will return Frank using my
> CONTAINS query, and I want the other results like "Frank" to be
> highlighted too. Anyone know a good way to go about doing this?
> Thanks
>