Grab text near match in fulltext

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

Is there a way to grab a bit of text near the first word the fulltext
search matches?

We're currently showing a summary to people, which is written by the
user, but obviously does not contain the keyword someone searched for.
And people think the search results are incorrect, but if they click
through they'll find the keyword is there.

I'm thinking MS SQL is not able to do this. Is there some other
product out there that does? We're using MS SQL 2005 Ent and
ColdFusion

Thanks in advance.
.

Relevant Pages

  • Re: Grab text near match in fulltext
    ... cc'ing him in this communication so he can jump in and help you. ... We're currently showing a summary to people, ... but obviously does not contain the keyword someone searched for. ... I'm thinking MS SQL is not able to do this. ...
    (microsoft.public.sqlserver.fulltext)
  • RE: Using an Object from a Current form for Criteria in a Query
    ... The keyword "Me" refers to the current form or report. ... a simple form with a textbox (which is named txtThisBox) and a button (which ... caption of the button to "SQL Ran" (I understand that this is not a likely ... Private Sub btnThisButton_Click ...
    (microsoft.public.access.formscoding)
  • Re: Error when calling the OleDbDataAdapter.Fill() method
    ... Have you tried copying and pasting the query into an Access query ... it is caused by using a keyword as a fieldname in my database. ... Here is the SQL statement I am executing (I am using Microsoft Access as my ... SELECT headline,url,summary,updated FROM worldnews EXCEPT (SELECT ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Using an Object from a Current form for Criteria in a Query
    ... The keyword "Me" refers to the current form or report. ... a simple form with a textbox (which is named txtThisBox) and a button (which ... caption of the button to "SQL Ran" (I understand that this is not a likely ... Private Sub btnThisButton_Click ...
    (microsoft.public.access.formscoding)
  • Re: collations and Unicode string processing
    ... is called for each keyword. ... You can also gain some performance by forcing a binary collation in ... Links for SQL Server Books Online: ...
    (microsoft.public.sqlserver.programming)