Hi Jeff,
Thank you for replying. I have actually researched some of your excellent work, but haven't been able to adapt this for my situation.
The string I am wanting to split will always have a semi-colon separator, so something like this:-
AA;BB;CC;DD;EE;FF;GG etc.
This string could potentially be split up to, say, 100 times or beyond.
As I am working with SQL 2012, I do not have the luxury of being able to use the new 2016 STRING_SPLIT function.
Thanks again! 🙂
Did Steve's good answer help you or are you still stuck with using an XML splitter?