Re: Full text newbie...

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
>>
>>
>
>


.

Relevant Pages

  • Re: Spend how much to get sent a McMaster catalog?
    ... > Tom Gardner wrote: ... > ...they said just call or use the web to request one. ... The elusiveness of their catalogs is legendary. ... After requesting a catalog about 3 ...
    (rec.crafts.metalworking)
  • RE: manipulating catalogs
    ... It sounds like you want to reorganize this catalog. ... but keep in mind that a LOCK will simply not allow access to the ... request fails. ... For IBM-MAIN subscribe / signoff / archive access instructions, ...
    (bit.listserv.ibm-main)
  • Re: Small Rant - Hancocks of Paducah
    ... When the order-taker person comes on the line request a catalog and explain to them. ... (You also get a catalog every time you order, so if you make a small purchase online they will send a catalog with the order.) ...
    (rec.crafts.textiles.quilting)
  • Re: Tooling supplier in Chicago area
    ... but it's fascinating education watching them do ... you can put in a request for a catalog if you ... building due to very screwy roads around them. ...
    (rec.crafts.metalworking)
Loading