title: Query a column and change value to numeric value
body: <p>I am using SQL Server 2012. I have a table which contains a column <code>MyCol</code> which can only be the four values below:</p>
  
  <pre><code>MN
  ABB
  BO 
  BN
  </code></pre>
  
  <p>When I query the data from my table I want to change these values to a numeric value instead, so say MN = 1, ABB = 2, BO = 3 &amp; BN = 4.</p>
  
  <p>How do I do this using a select statement?</p>