title: get all sub-strings within specified characters from a strings in SQL-2008
body: <p>Is it possible to get all sub-strings within particular characters, '#image' and '#' without using loop or what is the best way</p>
  
  <pre><code>declare @str nvarchar(max)='get all substrings #image:header# #image:footer#'
  </code></pre>
  
  <h3>expected result</h3>
  
  <blockquote>
    <p>Image</p>
    
    <hr>
    
    <p>header</p>
    
    <p>footer</p>
  </blockquote>