title: T-SQL substring between two slashes to extract data
body: <p>I am trying extract part of a string in T-SQL for a project I am working on.</p>
  
  <p>Examples:</p>
  
  <p>/Clients/AAA/Something/Something</p>
  
  <p>/Clients/BBBB/Something/Something</p>
  
  <p>I am specifically trying to extract the AAA or the BBB which are not a consistent number of characters. </p>