"tkaspro" <tkaspro@discussions.microsoft.com> wrote in message
news:8C89768D-E39C-4FB6-A11B-018AE3387059@microsoft.com...
> So I've got an FTS enabled table where I store several different types of
> documents (xls, doc, pdf) in a varbinary(max) field. All my searches pull
> back the proper results, but how do I show an extract of the actual text
> near
> the search terms? I would like to display the first 50 characters before
> and
> after the first hit so the user can put the result into context, before
> downloading the stored doc.
>
> Does Indexing Server do this? Because I haven't had much luck finding
> info
> on that either.

"tkaspro" <tkaspro@discussions.microsoft.com> wrote in message
news:296F2293-0245-4732-B2D5-21565F9377E5@microsoft.com...
> In my search to find an answer I had been to that indexserver site a
> couple
> of times, but I'm using 2005/.Net and most of the links for that section
> are
> either dead or say comming soon 1/31/05. I've looked over the hit
> highlighting
> page and it should give me something to play around with at least.
>
> So is there no way to use the iFilter interface to convert the document to
> text and insert that info into a varchar(max) as well as inserting the
> binary
> for storage purposes?
>
> "Hilary Cotter" wrote:
>
>> You can't really do this with varbinary or image columns. With char
>> variants
>> you can use charindex to highlight however it doesn't work well with
>> FreeText as stemmed words can vary considerably from the search term (ie
>> mouse and mice).
>>
>> It is better if you mark up char content on the client. Again with image
>> or
>> varbinary columns you can't do this. Here is a solution using Indexing
>> Services.
>>
>> http://www.indexserverfaq.com/SQLhitHighlighting.htm
>>
>> --
>> 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
>>
>>
>>
>> "tkaspro" <tkaspro@discussions.microsoft.com> wrote in message
>> news:8C89768D-E39C-4FB6-A11B-018AE3387059@microsoft.com...
>> > So I've got an FTS enabled table where I store several different types
>> > of
>> > documents (xls, doc, pdf) in a varbinary(max) field. All my searches
>> > pull
>> > back the proper results, but how do I show an extract of the actual
>> > text
>> > near
>> > the search terms? I would like to display the first 50 characters
>> > before
>> > and
>> > after the first hit so the user can put the result into context, before
>> > downloading the stored doc.
>> >
>> > Does Indexing Server do this? Because I haven't had much luck finding
>> > info
>> > on that either.
>>
>>
>>