Hi Jeef,

I just learned a function ... STUFF ... which solves the problem I was aware of relating to value chosen for the 3rd argument to SUBSTRING ... There isn't one! 🙂

Also, is merging the subquery WHERE clause into an AND on the JOIN merely personal preference or is it more efficient?