<p>There is a <a href="https://web.archive.org/web/20081014140251/http://stackoverflow.uservoice.com:80/pages/general/suggestions/16644" rel="nofollow noreferrer">request</a> to make the SO search default to an AND style functionality over the current OR when multiple terms are used.</p>
<p>The official response was:</p>
<blockquote>
<p>not as simple as it sounds; we use SQL Server 2005's <a href="https://learn.microsoft.com/en-us/previous-versions/sql/sql-server-2005/ms176078%28v=sql.90%29" rel="nofollow noreferrer">FREETEXT()</a> function, and I can't find a way to specify AND vs. OR -- can you?</p>
</blockquote>
<p>So, is there a way?</p>
<p>There are a <a href="https://learn.microsoft.com/en-us/previous-versions/sql/sql-server-2005/ms142519%28v=sql.90%29" rel="nofollow noreferrer">number of resources</a> on it I can find, but I am not an expert.</p>

As far as I've seen, it is
not
possible to do AND when using FREETEXT() under SQL 2005 (nor 2008, afaik).
A FREETEXT query ignores Boolean, proximity, and wildcard operators by design. However you could do this:
```
```
WHERE FREETEXT('You gotta love MS-SQL') > 0
 AND FREETEXT('You gotta love MySQL too...') >  0
```
```
Or that's what I think :)
-- The idea is make it evaluate to Boolean, so you can use boolean operators. Don't know if this would give an error or not. I think it
should
work. But reference material is pointing to the fact that this is not possible by design.
The use of CONTAINS() instead of FREETEXT() could help.