Well that burst my bubble. I have not given up on the suggestions you gave. I just don't understand them and cannot figure out how to make them worth with my dataset. Yes, this is due to my lack of knowledge. I wanted to at least have SOMETHING that works, and that I understand, in my pocket. That does not mean that this is the code that I will go with. I have never used WITH or CROSS APPLY before and I don't know if i will be able to deploy the DelimitedSplit8K function in our environment.

I very much do appreciate your help, but this project is on a timeline and like I say, I wanted something that was at least functional as a fall back. I will need to discuss all of my options with my boss. He may understand your code and recommend going with it and may be able to explain it, but I wanted something to show that I have at least been working on this within my skill set.

Can you explain (or refer me to a reference) that would help explain what is going on in your example? I mean, even if it did work perfectly in my situation, I don't like using code that I don't fully understand.

PK