Binary full text searches w/ sample

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kevin.w.Berridge@gmail.com - 23 Aug 2006 19:11 GMT

In SQL Server 2005 I can use full text searching on a varbinary(max)
column containing a Word document (for example). When I return the
results of the search, I would like to return a snippet of the text
which matched the query to give my users some idea of why that document
matched. Is there a way to do this in SQL Server 2005? Or is there
some way to get this from the indexing service?

Thanks!
Kevin

Reply to this Message

Hilary Cotter - 23 Aug 2006 19:59 GMT

You can't do this, unless you extract the text and store it in another
column and then use charindex. Here is a link on how to integrate it with
Indexing Services.

http://www.indexserverfaq.com/SQLHitHighlighting.htm

Signature

Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

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

> In SQL Server 2005 I can use full text searching on a varbinary(max)
> column containing a Word document (for example). When I return the
[quoted text clipped - 5 lines]
> Thanks!
> Kevin

Reply to this Message