title: Split string to substrings on a character and turn into multiple lines SQL
body: <p>I have the following table:</p>
  
  <pre><code>+--------+-----------------+
  |  Code  |      Input      |
  +--------+-----------------+
  | 151821 | 687 235 563     |
  | 123521 | 657 089 568 798 |
  +--------+-----------------+
  </code></pre>
  
  <p>What I want to be able to do is split the "Input" string on the space character in a SQL view (which will then populate an excel query) to create something like this:</p>
  
  <pre><code>+--------+-------+
  |  Code  | Input |
  +--------+-------+
  | 151821 |   687 |
  | 151821 |   235 |
  | 151821 |   563 |
  | 123521 |   657 |
  | 123521 |   089 |
  | 123521 |   568 |
  | 123521 |   798 |
  +--------+-------+
  </code></pre>
  
  <p>I know I could do it at Excel level with a bit of VBA using the <code>SPLIT</code> function on the spaces, but was hoping there may well be a way to do it in SQL as well.</p>