Can You Perform An AND Search Of Keywords Using FREETEXT() On SQL Server 2005?
There is a request to make the SO search default to an AND style functionality over the current OR when multiple terms are used.
The official response was:
not as simple as it sounds; we use SQL Server 2005's FREETEXT() function, and I can't find a way to specify AND vs. OR -- can you?
So, is there a way?
There are a number of resources on it I can find, but I am not an expert.
OK, this change is in -- we now use
CONTAINS() with implicit
AND instead of
FREETEXT() and its implicit
- → How to create decimal variable dynamically in SQL Server
- → How to ensure non-null duplicate values are not inserted in SQL Server 2005
- → SQL Server 2005 implementation of MySQL REPLACE INTO?
- → Deploying SQL Server Databases from Test to Live
- → Why doesn't VFP .NET OLEdb provider work in 64 bit Windows?
- → Client collation and SQL Server 2005
- → Why doesn't SQL Full Text Indexing return results for words containing #?
- → Have you ever encountered a query that SQL Server could not execute because it referenced too many tables?
- → SQL Server 2005 For XML Explicit - Need help formatting
- → Paging SQL Server 2005 Results
- → Error while refreshing a MS datawarehousing cube
- → Storing credentials in SSRS 2005
- → DELETE Statement hangs on SQL Server for no apparent reason