title: Retrieve String Between Two Delimiters for Multiple Occurences SQL Server
body: <p>How can i get the result set as TESTING1,TESTING2 from below </p>
  
  <pre><code>DECLARE @MyString varchar(256) = '$I10~TESTING1$XYZ$I10~TESTING2$~'
  </code></pre>
  
  <p>Basically i need to get all the substrings which are in between $I10~ and $ </p>