title: Getting the Max values from a varchar field
body: <p>I have a varchar field as my Employee ID and it is formated like this: </p>
  
  <p>Format: YYYY-DateHired-Number 
  Example: 2012-1203-0001 </p>
  
  <p>But Im having hard time in inserting new record because  to insert a new incremented ID, 
  I need to get the latest value in this field before I increment it. </p>
  
  <p>How can I get the row with the latest/highest (MAX) Numberin the most recent year? </p>
  
  <p>Thanks in advance :) </p>