title: Use of right in standard SQL in BigQuery
body: <p>While running the following code in standard SQL in BigQuery, I'm getting an error stating </p>
  
  <pre><code>#standardSQL
  UPDATE dataset.dataset
  SET New_column = RIGHT(link_id, LEN(link_id) - 3)
  WHERE TRUE
  
  
  Error: Syntax error: Unexpected keyword RIGHT at [8:18]
  </code></pre>