• craig.jenkins - Friday, December 15, 2017 7:51 AM

    HI Drew, whilst I appreciate what you are saying;  as a newbee to sql all I'm trying to do is find a solution to a problem,  The solution ChrisM gave me to the initial index match query is perfect and exactly what I need I'm just trying to build on that.

    If you had a problem, you would be able to tell us what results you expect.  What you have is an approach (INDEX MATCH) looking for a problem, which is why you're unable to specify expected results.

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA