title: 'TRIM' or 'PROPER' in BigQuery
body: <p>is there a way to normalize strings in BigQuery?</p>
  
  <p>My dataset looks like:</p>
  
  <blockquote>
    <p><strong>Alfa Beta</strong></p>
    
    <p><strong>Alfa  BETA</strong></p>
    
    <p><strong>alfa beta</strong>    <em>//with a space after 'beta'</em></p>
  </blockquote>
  
  <p>By now I can use <strong>lower</strong> or <strong>upper</strong> to normalize the letters but I don't know how to eliminate spaces before and after the text. Does BigQuery have a function like '<em>TRIM</em>' in Excel?</p>