title: Get the text between two characters in sql server
body: <p>i have tried using charindex function but unable to get it.</p>
  
  <p>Text is :- Offshore/BLR/IN</p>
  
  <p>i want only BLR" out of this.</p>
  
  <p>please help.</p>