title: Split string and Remove last value
body: <p>I've to split string by using <code>'/'</code>.</p>
  <p>Input:</p>
  <pre><code>INTC/MODB2/0241-07133/0010-81717/0010-36299
  </code></pre>
  <p>I have to loop through it and the expected output is like:</p>
  <pre><code>INTC/MODB2/0241-07133/0010-81717/0010-36299
  INTC/MODB2/0241-07133/0010-81717
  INTC/MODB2/0241-07133
  INTC/MODB2
  INTC
  </code></pre>
  <p>I tried using split function, but I'm able to print the exact output</p>
  <pre><code>SELECT value 
  FROM STRING_SPLIT('INTC/MODB2/0241-07133/0010-81717/0010-36299', '/');
  </code></pre>
  <p>Appreciate any help</p>