Grab text near match in fulltext

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.
You have to code your own solution.
You might want to talk to michal at devmasters.cz. He has a solution. I am
cc'ing him in this communication so he can jump in and help you.
http://www.zetainteractive.com - Shift Happens!
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Pacific Fox - Web Design Brisbane" <tacofleur@.gmail.com> wrote in message
news:63bbaacc-e8be-4280-9a98-5af5edbaa4ae@.b1g2000pra.googlegroups.com...
> 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.