title: How to get the month from a string in sql?
body: <p>I have to get the month  from a column which stores string in format - </p>
  
  <pre><code>Column
  ----------
  `Feb2007'     
  'Sep2008'
  </code></pre>
  
  <p>So if the value was <code>'Feb2007'</code> then I need to get back <code>2</code> or else if the value was <code>'Sep2009'</code> then I should get back <code>9</code>.</p>
  
  <p>Is there inbuilt function in SQL Server 2008 to achieve something like this?</p>