title: SQL CONTAINS or FREETEXT
body: <p>Im trying to use either CONTAINS or FREETEXT in SQL programing to be able to search couple words all at the same time. The issue is when you search couple words FREETEXT or CONTAINS will search by column not by row for example:<br>
  Imagine this is my database</p>
  
  <pre><code>id        | c1      | c2 
  ===============================
  a         | 1       | 2     
  b         | 1       | 3     
  c         | 1       | 2     
  d         | 2       | 2     
  e         | 3       | 3     
  f         | 2       | 1 
  </code></pre>
  
  <p>When you search <code>CONTAINS(*, '1,2')</code> OR off curse <code>FREETEXT(*, '1 2')</code> it will return  </p>
  
  <pre><code>id        | c1      | c2 
  ===============================
  a         | 1       | 2     
  b         | 1       | 3     
  c         | 1       | 1     
  d         | 2       | 2     
  e         | 2       | 3     
  f         | 2       | 1 
  </code></pre>
  
  <p>Which is basically entire database. But what I wanted was this  </p>
  
  <pre><code>id        | c1      | c2 
  ===============================
  a         | 1       | 2     
  f         | 2       | 1 
  </code></pre>
  
  <p>Which is the rows that contains 1 and 2 combine.  </p>
  
  <p>By the way I'm using SQL 2008 and ASP classic.</p>
  
  <p>I would really appreciate for your suggestion.</p>