Re: using AND accross multiple fields

Tech-Archive recommends: Speed Up your PC by fixing your registry

Sorry about that, I did the clasic newsgroup no-no of posting a
questions before searching. After I did a search I found this topic
discussed all over the place. I deleted my post but not in time.

Thanks for your response anyway.

Hilary Cotter wrote:
In SQL 2000 a freetext query would do what you are looking for. This has
changed in SQL 2005.

I think your best bet would be to have a third column which is also
full-text indexed and is a concatenation of the previous two 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



"ddaiker" <ddaiker@xxxxxxxxx> wrote in message
news:1168279934.592635.327390@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
In SQL Server 2005 it seems that if multiple columns in a table are
included in the FTI and you do a CONATAINS query using AND accross all
columns all the terms must be in one column. Is this correct?

Example:

MyTable
ID TheText MoreText
-------------------------------------------
1 alpha beta gamma delta

and my query

SELECT * FROM MyTable WHERE CONTAINS(*,'beta AND gamma')

This returns no rows. Is this the expected behaviour? Is there any
way to get it to ignore the different columns and treat it as one?


.

Relevant Pages

  • Re: Newbie question:why use stack in Full-Text index?
    ... Basically if you are searching on a single term a btree like index makes ... Director of Text Mining and Database Strategy ... Looking for a SQL Server replication book? ... Looking for a FAQ on Indexing Services/SQL FTS ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Undescribed Error
    ... permissions/authentication problem on the data access level. ... that the account has rights to access the publication. ... Looking for a SQL Server replication book? ... > searching for similar error but to no end. ...
    (microsoft.public.sqlserver.replication)
  • Re: does iFilter 5.0 work with PDF made by Acrobat 6?
    ... > of searching the Acrobat properties. ... >>Hilary Cotter ... >>Looking for a book on SQL Server replication? ...
    (microsoft.public.inetserver.indexserver)
  • Re: Searching for filenames and numbers failing
    ... Looking for a SQL Server replication book? ... I am using a simple ixsso query to query my index. ... > The query is using either '@contents 0092339' for searching document ... or '@filename 0092339' for searching filenames. ...
    (microsoft.public.inetserver.indexserver)
  • Re: Searching for Keywords using Indexing Service
    ... Looking for a SQL Server replication book? ... "Richard" wrote in message ... > I am looking for a way of searching for Meta Keywords ...
    (microsoft.public.inetserver.indexserver)