<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>

[{'answer_id': 25287, 'author': 'Martin Marconcini', 'author_id': 2684, 'author_profile': 'https://Stackoverflow.com/users/2684', 'pm_score': 2, 'selected': False, 'text': "<p>As far as I've seen, it is <strong>not</strong> possible to do AND when using FREETEXT() under SQL 2005 (nor 2008, afaik). </p>\n\n<p>A FREETEXT query ignores Boolean, proximity, and wildcard operators by design. However you could do this: </p>\n\n<pre><code>WHERE FREETEXT('You gotta love MS-SQL') &gt; 0\n AND FREETEXT('You gotta love MySQL too...') &gt;  0\n</code></pre>\n\n<p>Or that's what I think :)</p>\n\n<p>-- 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 <em>should</em> work. But reference material is pointing to the fact that this is not possible by design. </p>\n\n<p>The use of CONTAINS() instead of FREETEXT() could help.</p>\n"}, {'answer_id': 25303, 'author': 'Rob Allen', 'author_id': 149, 'author_profile': 'https://Stackoverflow.com/users/149', 'pm_score': 1, 'selected': False, 'text': '<p>I just started reading about freetext so bear with me. If what you are trying to do is allow searches for a tag, say VB, also find things tagged as VB6, Visual Basic, VisualBasic and VB.Net, wouldn\'t those values be set as synonyms in the DB\'s Thesaurus rather than query parameters?</p>\n\n<p>If that is indeed the case, this <a href="http://msdn.microsoft.com/en-us/library/ms345187.aspx" rel="nofollow noreferrer">link on MSDN </a> explains how to add items to the Thesaurus.</p>\n'}, {'answer_id': 25456, 'author': 'Jeff Atwood', 'author_id': 1, 'author_profile': 'https://Stackoverflow.com/users/1', 'pm_score': 2, 'selected': True, 'text': '<p>OK, this change is in -- we now use <code>CONTAINS()</code> with implicit <code>AND</code> instead of <code>FREETEXT()</code> and its implicit <code>OR</code>.</p>\n'}]
['https://Stackoverflow.com/questions/25277', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/2134/']