title: Case Sensitivity in google spreadsheet queries
body: <p>I just want to use a query in google spreadsheet that is not case sensitive on a string with regular cell reference. So here is what I do:</p>
  
  <pre><code>=QUERY(Website!$A16:$D, "select B WHERE (C='"&amp;$B$1&amp;"' OR B contains '"&amp;$B$1&amp;"')", -1)
  </code></pre>
  
  <p>So B1 obviously contains the String I am looking for. Unfortunately both "=" and "contains" are somehow case sensitive. Do you have an idea to work around that?</p>
  
  <p>Thanks
  Florian</p>