title: Split words with a capital letter in sql
body: <p>Does anyone know how to split words starting with capital letters from a string?</p>
  
  <p>Example:</p>
  
  <pre><code>    DECLARE @var1 varchar(100) = 'OneTwoThreeFour'
      DECLARE @var2 varchar(100) = 'OneTwoThreeFourFive'
      DECLARE @var3 varchar(100) = 'One'
  
      SELECT @var1 as Col1, &lt;?&gt; as Col2
      SELECT @var2 as Col1, &lt;?&gt; as Col2
      SELECT @var3 as Col1, &lt;?&gt; as Col2
  </code></pre>
  
  <p>expected result:</p>
  
  <pre><code>    Col1                Col2
      OneTwoThreeFour     One Two three Four
      OneTwoThreeFourFive One Two Three Four Five
      One                 One
  </code></pre>
  
  <p>If this is not possible (or if too long) an scalar function would be okay as well.</p>