title: compress() function in BigQuery
body: <p>I have some String fields in BQ that I would like to remove spaces from.  In SAS, there is a function compress().  Is there a comparable function in BQ?</p>
  
  <pre><code>WHERE firstname is not null
  </code></pre>
  
  <p>does not remove those records where there is a single space, for example.</p>
  
  <p>Thanks!</p>