Fulltext search results

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Maycel Kollau - 29 Jun 2006 10:24 GMT

Hi,

is it possible to return detailed information about fulltext searc
results, like linenumbers ?
I'm fairly new to using the fulltext search funtionality. I have bee
playing around with it for a few days now. Does anyone know if this i
possible ?

Thanks,
Mayce

--
Maycel Kolla

Reply to this Message

Hilary Cotter - 29 Jun 2006 13:22 GMT

No, its not possible to return this form of information. You would have to
use charindex or patindex to locate the location of your hit.

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

> Hi,
>
[quoted text clipped - 6 lines]
> Thanks,
> Maycel

Reply to this Message

Maycel Kollau - 30 Jun 2006 16:04 GMT

I'm using fulltext search to search for words in BLOB's stored in
varbinary(MAX) field.

Do you have any suggestions how to generate usefull extra informatio
for search results using these functions

--
Maycel Kolla

Reply to this Message