title: SQL SUBSTRING to extract all parts of a column
body: <p>I am trying to extract values from a column using the SQL SUBSTRING method. The values from the column are in this format: <code>VI_{13446F4A-DAC2-44AD-BDAB-86E6F2546DE6}_20220122T090159</code>.
  I am trying to obtain all substrings delimited by the <code>_</code> character.
  I have managed to extract the first part, but I did not find a way for the others using:</p>
  <pre><code>DECLARE @Str nchar(200);
  SET @Str = 'VI_{13446F4A-DAC2-44AD-BDAB-86E6F2546DE6}_20220122T090159'
  
  SELECT SUBSTRING(@Str, 1, CHARINDEX('_', @Str) -1) AS F1,
         SUBSTRING(@Str, CHARINDEX('_', @Str)+1, LEN(@Str)) AS F2
  </code></pre>
  <p>The code above gives me F1 correct, but F2 is incorrect:</p>
  <pre><code>F1 = VI
  F2 = {13446F4A-DAC2-44AD-BDAB-86E6F2546DE6}_20220122T090159
  </code></pre>
  <p>How can I get the other two parts?</p>
  <p>Thanks!</p>