Highlight Keywords

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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

.

Relevant Pages

  • Re: Highlight Keywords
    ... to highlight the resultset keywords from the full text results. ... search terms with the sql server resultset. ... and I want the other results like "Frank" to be ...
    (microsoft.public.sqlserver.fulltext)
  • Re: getting DestinationObjectName from package using VB6
    ... I meant to highlight the lack of Set as required object ... assignment, and thought I'd include a full code sample, but ... global community for SQL Server professionals ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL Server 2005 Licensing concern.
    ... even has stuff like lunching the query builder in the middle of a stored ... proc (just highlight the sql..right click). ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Query SQL using variables.
    ... If you have SQL Server on the machine and it is SQL Server 2000, then you will start SQL Server Query Analyzer and past the SQL text into the pane, highlight and execute it. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Number of documents vs rank in FTS
    ... especially if I start writing procedures to query the index using ... document frequency of a boolean query in SQL server*, ... > document collection or the frequency that words occur compared to the ... >> frequency to penalize the number of occurrences for keywords common ...
    (microsoft.public.sqlserver.fulltext)