Search code examples
sql-server-2005searchfull-text-searchfreetext

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.


Solution

  • OK, this change is in -- we now use CONTAINS() with implicit AND instead of FREETEXT() and its implicit OR.