title: SQL to find string in select
body: <p>I have a select statement like this:</p>
  
  <pre><code>SELECT ColumnA,
  CASE ColumnB = 'England' THEN ...
  </code></pre>
  
  <p>In the part after the THEN statement, i want to take the numbers from ColumnC, </p>
  
  <p>e.g. ColumnC value = ABC 123 DEF, and i need the '123' part. </p>
  
  <p>Does anyone know the sql code i can use to do this within the select when the '123' will always be in between the only 2 spaces in the string? (MS SQL)</p>