title: Find position of delimited character in a String (SQL Server)
body: <p>I have a string Variable </p>
  
  <p><strong>test=HARIA|123|MALE|STUDENT|HOUSEWIFE</strong></p>
  
  <p>i am using <strong>|</strong> as delimited character. if i want to extract data from 2nd occurence of pipe till 3rd occurrence.  i need to get 'MALE' from above string.</p>
  
  <p>any help appreciated</p>