title: Adding 1 to time column of strings in Google BigQuery Standard SQL
body: <p>Column is a string for time of Year+FiscalWeek, such as "201916".</p>
  
  <p>I've used REPLACE(COLUMN, "2019", "") to leave the column at week number, column now = "16"</p>
  
  <p>But now I'm joining on this week with another table that is offset by one week.
  I'd like to now add 1 to each entry down the column, such as 16=17, 18=19.</p>