Re: Full text newbie...
- From: "Renato Aranghelovici" <renatoa@xxxxxxxxxx>
- Date: Mon, 30 Jan 2006 11:54:31 +0200
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
"Hilary Cotter" <hilary.cotter@xxxxxxxxx> wrote in message
news:u1CeLYVIGHA.3348@xxxxxxxxxxxxxxxxxxxxxxx
> Not really. Both words must be in the same column with a Contains search,
> a FreeText search can look across columns.
>
> --
> 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
>
> "Renato Aranghelovici" <renatoa@xxxxxxxxxx> wrote in message
> news:OYRS%234SIGHA.3000@xxxxxxxxxxxxxxxxxxxxxxx
>> 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
>>
>>
>
>
.
- References:
- Full text newbie...
- From: Renato Aranghelovici
- Re: Full text newbie...
- From: Hilary Cotter
- Full text newbie...
- Prev by Date: Re: Text field in a group by, how can I make it work?
- Next by Date: Ignored words error strangeness
- Previous by thread: Re: Full text newbie...
- Next by thread: incremental Population not starting
- Index(es):
Relevant Pages
|
Loading