title: How to stop upper() from being pulled through as part of Google Sheets QUERY?
body: <p>I'm unable to find a way of making sure that upper() is not pulled through when using the QUERY function on Google, specifically with SELECT.</p>
  
  <p>I have an example below:</p>
  
  <p><code>=QUERY(countries, "SELECT UPPER(C)", 1)</code></p>
  
  <p>But this outputs upper() as one of the cells. In this case the first item of the column is Continent so this pulls through as "upper(Continent)</p>
  
  <p><a href="https://docs.google.com/spreadsheets/d/1qcFNEnk420dJAM5JNedom3-ZqIwpHK4GHEPfLpMFDvc/edit?usp=sharing" rel="nofollow noreferrer">Example Spreadsheet here</a></p>
  
  <p>Does anyone know how to fix this so that upper() doesn't appear at all?</p>