Re: Full text newbie...

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: Can I delete the gather logs?
    ... Can you export the registry key for this catalog and post it here? ... Hilary Cotter ... it definitely was not finished populating when it was idle ... ... I think part of the confusion may be that the registry key that you ...
    (microsoft.public.sqlserver.fulltext)
  • Re: cant move file for full-text index
    ... "Hilary Cotter" wrote: ... For example the command SELECT name FROM SYS.DATABASE_FILES ... the alter database command I still get the same error message. ... determine the logical name of your full-text catalog file. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Backup failure due to full-text indexing
    ... were getting catalog corruption errors but these were due to something else. ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... "Hilary Cotter" wrote: ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Manually Delete FullText Catalog
    ... > So I can't delete the Catalog or even know it name!!! ... > "Hilary Cotter" wrote in message ... >> Create table holding ... >> TABLE_OWNER sysname, ...
    (microsoft.public.sqlserver.fulltext)
  • Re: "CONTAINS" ignores "fahrenheit"?
    ... MSSearch and rebuild your catalog. ... >> Hilary Cotter ... >> Looking for a book on SQL Server replication? ...
    (microsoft.public.sqlserver.fulltext)
Loading