Steve and David I really appreciate your insight, time, support and immediate responses!!

FYI...This is purely a data manipulation tool in a c# application that will extract certain data, analyze, reorganize...

I do not see how CHARINDEX can work for variable length strings.

Although it is in fact XML data, I am only manipulating the text, not working with the XML in...