title: Trim first two characters from year of GETDATE()
body: <p>I am trying to create a WHERE clause that says </p>
  
  <pre><code>WHERE column_1 = TRIM(LEADING '20' FROM(DATEPART(year, GETDATE())))
  </code></pre>
  
  <p>Basically <code>column_1</code> contains the fiscal year but the fiscal year is in the database as  8 or 9 not 2008 or 2009.</p>
  
  <p>So I need to figure a way to trim off at least the <code>'20'</code> so that the query will run correctly... The more dynamic the better because I need to set this up to run in an SSIS pkg and the less hard coding the better.</p>
  
  <p>Any suggestions?
  Thanks in advance!
  Jon</p>