title: concatenate two columns in specific format in SQL
body: <p>I have the below line of my query,</p>
  
  <pre><code>concat(fiscalyear,fiscalweek) as yearweek,
  </code></pre>
  
  <p>week 1 of year 2016 is displayed as 20161, however I need it to display as 201601, and week 10 would look like 201610,</p>
  
  <p>how do I format the column fiscalweek ?</p>
  
  <p>please don't shoot me down I am very new</p>