title: SQL select to get a string between two spaces
body: <p>I have a field with names in the format DOE JOHN HOWARD or DOE JOHN H.</p>
  
  <p>I need a query to get the string between the two spaces (JOHN in this case).</p>
  
  <p><a href="https://stackoverflow.com/questions/18362260/a-sql-query-to-select-a-string-between-two-known-strings">The SO answer here</a> shows how to do that when the desired substring is between two <strong>different</strong> strings, but I don't see how to apply something similar when the desired substring is between two instances of the same string (a space in this case).</p>
  
  <p>How can I do that?</p>