title: Cannot pull multiple criteria via QUERY when enclosed in a LOWER(a) function
body: <p>I am trying to get data from a Data range titled DealFinders. I have the columns I want to pull in via Query. I need to be able to pull using one Query function, multiple values that are run through a lower(##) function with the query.</p>
  
  <p>Here's the code that works with the states listed as GA, ga, Ga, gA:</p>
  
  <pre><code>=IFERROR(
  QUERY(
  DealFinders, 
  "select A,B,C,D,E,F,G,H,I,J,N,L,M,K,O,P,Q,R 
  where
  lower(L) contains lower('GA') order by R, 0"),
  "No Results")
  </code></pre>
  
  <hr>
  
  <pre><code>=IFERROR(
  QUERY(
  DealFinders, 
  "select A,B,C,D,E,F,G,H,I,J,N,L,M,K,O,P,Q,R 
  where
  " lower(L) contains lower('GA') order by R, 0 " &amp; " AND " &amp; "
    lower(L) contains lower('NC') order by R, 0 ""),"No Results")
  </code></pre>
  
  <p>The query should show all the people who are in the states GA (Georgia) or NC (North Carolina).</p>