title: How can I get the almost last substring from "/" delimited string in T-SQL?
body: <p>If I've got a string that consists of other strings delimited with "/" character (xxx...xxx/xxx/xxxx) how can I get the last and the almost last (the one before last) part with t-sql? It should probably be some combination of charindex() and right(). </p>