title: T-SQL get sub-string up to but not including first single forward slash
body: <p>Using T-SQL, I would like to retrieve the sub-string up to but not including the first single forward-slash. For example:</p>
  
  <p>"<a href="https://domain/xyz/" rel="nofollow noreferrer">https://domain/xyz/</a>" should become "<a href="https://domain" rel="nofollow noreferrer">https://domain</a>"</p>
  
  <p>Would appreciate some guidance on how to accomplish this.</p>