using AND accross multiple fields
- From: "ddaiker" <ddaiker@xxxxxxxxx>
- Date: 8 Jan 2007 10:12:14 -0800
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?
.
- Follow-Ups:
- Re: using AND accross multiple fields
- From: Hilary Cotter
- Re: using AND accross multiple fields
- Prev by Date: Re: Passing Parameters into a Full text search Query
- Next by Date: Re: using AND accross multiple fields
- Previous by thread: Re: Passing Parameters into a Full text search Query
- Next by thread: Re: using AND accross multiple fields
- Index(es):