title: how to remove the extra AND from the loop
body: <pre><code>foreach (string word in allTheseWords)
  {
  allTheseStringsWhereClause = allTheseStringsWhereClause + 
                               " report=" + 
                               word + 
                               " AND ";
  }
  </code></pre>
  
  <p>The problem is after the loop, the SQL clause has an extra <code>AND</code> at the end of it.</p>
  
  <p>How do I fix this?</p>