title: Extracting a string from data field in sql server
body: <p>I am trying to select the string between every pair &lt;....> in the fifth column "QuestionTags".</p>
  
  <p>here is a sample of the data:</p>
  
  <p><a href="https://i.stack.imgur.com/cBvjj.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/cBvjj.png" alt="enter image description here"></a></p>
  
  <p>i used CHARINDEX function but it returned me an integer. </p>
  
  <p>i also used SUBSTRING but it asks me to define the character index and length of string.</p>
  
  <p>Any suggestions? </p>