title: SQL obtaining the last two digits of integer
body: <p>I need to obtain the last two digits of an integer. Each element placed in the tables comes as a full year ie. <code>YYYY</code> and I only want the last two digits, so that all the fields show</p>
  
  <pre><code>YEAR
  ----
  09
  00
  89
  </code></pre>
  
  <p>where the initialy field was</p>
  
  <pre><code>YEAR
  ----
  2009
  2000
  1989
  </code></pre>
  
  <p>EDIT: I get a complaint saying, </p>
  
  <p><code>HINT:  No function matches the given name and argument types. You might need to add explicit type casts.</code></p>
  
  <p>when i try</p>
  
  <p><code>select right(cast(year as char),2) from subjects;</code></p>