title: SQL Server 2000: how to replace a entry with only the last 2 characters
body: <p>I have a table in a SQL Server 2000 database with a column with several entries like <code>01-03</code>, <code>04-05</code>. The first 2 digits are the room number and the last two digits are the bed number.</p>
  
  <p>I want to replace the <code>01-05</code>, <code>03-07</code> etc. with only the bed number. So only the last two charcters have to be in the column.</p>
  
  <p>How do I accomplish this?</p>
  
  <p>Sample data is:</p>
  
  <p>In the column <code>[Bed]</code> with values:</p>
  
  <pre><code>22-01
  08-01
  09-03
  01-16
  </code></pre>
  
  <p>Result has to be:</p>
  
  <pre><code>01
  01
  03
  16
  </code></pre>