title: SQL server split string into columns by delimiter (dynamic length)
body: <p>SQL server cannot use MySQL split_index function, and my environment face accessibility blocking to use some function on server like <code>"CREATE" "INSERT"</code></p>
  
  <p>Are there any method to split strings by fixed delimiter into columns ?
  Has 3 delimiters but length is dynamic.
  e.g.
  STRING : sometimes - <code>"AA.0.HJ"</code>, sometimes - <code>"AABBCC.099.0"</code>,sometimes - <code>"0.91.JAH21"</code></p>
  
  <p>The combinations of substring is not work.</p>
  
  <pre><code>SUBSTRING(STRING , 
              CHARINDEX('.', STRING )+1, 
              LEN(STRING )-CHARINDEX('.', STRING )
  Origin:
  STRING 
  AA.0.HJ
  AABBCC.099.0
  0.91.JAH21
  
  Target :
  STRING        First    Second  Third
  AA.0.HJ       AA       0       HJ
  AABBCC.099.0  AABBCC   099     0
  0.91.JAH21    0        91      JAH21
  </code></pre>
  
  <p>What is the solution in this situation ?</p>