title: Remove the first two digits from year - Postgresql
body: <p>I have a table with year, term as fields. The current values in the table is in this format:</p>
  
  <pre><code>year | term
  ------------
  2006 | S1
  2007 | S2
  2009 | S1
  2010 | S2
  </code></pre>
  
  <p>I am using the following code to no success:</p>
  
  <pre><code>select concat (replace(term, 'S', 's'), year) as test from semesters;
  </code></pre>
  
  <p>I get the following results:</p>
  
  <pre><code>Test
  ----
  s12006
  s22007
  s12009
  s12010
  </code></pre>
  
  <p>I want to run a query where I will get the result in this format:</p>
  
  <pre><code>Test
  -----
  s106
  s207
  s109
  s210
  </code></pre>
  
  <p>Please give me some pointer on how to achieve this in postgresql. Thanks</p>