title: Query for does not contain
body: <p>I have a sheet that queries three others in the same document and selects a bunch of rows where the column G contains <code>no</code>. Ideally I would prefer it be a query that does not contain the word <code>yes</code> or <code>Yes</code>. I have tried using all of the following mechanisms:</p>
  
  <ul>
  <li>where not (G contains 'yes')</li>
  <li>where not (G contains 'es')</li>
  <li>where not (G matches '[yY]es')</li>
  <li>where G contains 'no'</li>
  </ul>
  
  <p>and no matter which one I pick I run into one of two issues:  </p>
  
  <p>Issue number 1 is that part of the query fails because only one of the values is present. Ie there is a <code>Yes</code> but not a <code>yes</code>, which results in the output of <code>#VALUE</code>. This is problematic because I am trying to allow for both scenarios since I cannot control what the end user of this will input into the sheet.</p>
  
  <p>or Issue number 2 which is far worse. When I specifically say select all where G contains <code>no</code> one of the rows that displays contains a <code>yes</code>. Note that this also occurs with some of the other mechanisms as well but I would think specifically saying <code>no</code> should prevent this and does not.</p>
  
  <p>The full query I am using is:  </p>
  
  <p><code>=ARRAYFORMULA({QUERY(Sheet1!A2:I500, "Select A, B, C, D, E, F, G, H, I where G contains 'no'");(QUERY(Sheet2!A2:I500, "Select A, B, C, D, E, F, G, H, I where G contains 'no'"));(QUERY(Sheet3!A2:I500, "Select A, B, C, D, E, F, G, H, I where G contains 'no'"))})</code></p>
  
  <p>What am I doing wrong here? </p>