Re: using AND accross multiple fields

Tech-Archive recommends: Fix windows errors by optimizing your registry

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: DBMS and lisp, etc.
    ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
    (comp.lang.lisp)
  • Re: Populating a list -- table structure?
    ... I had made a report already and figured out about adding the ... your responce below, but thanks to your help with SQL, I was able to get the ... It takes a summary from a select query and gives the ... KitID, long integer ...
    (microsoft.public.access.forms)
  • How do I do Paging through a large dataset via Stored Procedures
    ... Paging by dynamically altering the SQL Query ... Create stored procedures ... SELECT * FROM STUDENTS ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Populating a list -- learning Access
    ... It is kinda funny -- I started using databases in the early 80's with dBase and, for years, never knew that I knew SQL! ... If you are on a form or report, the most important property is the NAME, because that is how you refer to it in code. ... I don't mean to skip your responce below, but thanks to your help with SQL, I was able to get the query to pull the info the way I needed. ... Queries (just shows the QBE grid for convenience -- ...
    (microsoft.public.access.forms)
  • Re: Populating a list -- table structure?
    ... I don't mean to skip your responce below, but thanks to your help with SQL, I was able to get the query to pull the info the way I needed. ... I have one report complete, ... Queries (just shows the QBE grid for convenience -- ...
    (microsoft.public.access.forms)