Full text newbie...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Renato Aranghelovici - 24 Jan 2006 21:36 GMT

Hi, group,

Made these days some tests and not understand very clear how contains or
containstable perform the search.
The catalog was built on 2...5 columns, various scenarios.
I tried with 2 words I am sure they exists in 2 different fields, but
contains nor containstable does not return those records. I tried both
"Johny Walker" and "Johny" AND "Walker" and no succes.
Is there any syntax allowing me to find "Johny" in a field AND "Walker" in
other field, in the same record, both fields included in FT catalog?

Thank you,
Renato

Reply to this Message

Hilary Cotter - 25 Jan 2006 02:21 GMT

Not really. Both words must be in the same column with a Contains search, a
FreeText search can look across columns.

Signature

Hilary Cotter
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, group,
>
[quoted text clipped - 9 lines]
> Thank you,
> Renato

Reply to this Message

Renato Aranghelovici - 30 Jan 2006 09:54 GMT

Ok, thank you.
This responded only partially to my initial request: if I want to find all
records that contains "Johny" in any indexed field AND "Walker" in other
indexed field ( or both in the same field) is this possible with free text
search ? And how?

Thank you,
Renato

> Not really. Both words must be in the same column with a Contains search,
> a FreeText search can look across columns.
[quoted text clipped - 12 lines]
>> Thank you,
>> Renato

Reply to this Message