title: How to Remove Diacritic Marks (such as Accents) using Unicode Normalization in Standard SQL?
body: <p>How can we remove diacritic marks from strings in BigQuery using the new <a href="https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#normalize" rel="noreferrer"><code>normalize</code></a> function such as:</p>
  
  <pre><code>café
  </code></pre>
  
  <p>To result:</p>
  
  <pre><code>cafe
  </code></pre>