title: Substring Charindex help to extract (T-SQL)
body: <p>How would I get the last section after the last "/"?</p>
  
  <p>/{ct6yr356-051t-55e2-b89r-546454ab922}/location/Missouri/costcenter/TXX1/Sales Orders on Queue.rdl</p>
  
  <p>Sales Orders on Queue &lt;-- The part I want to extract. There are always six of '/' and .rdl at the end.</p>
  
  <p>The language is T-SQL.</p>