• Have you tried using TRY_CAST( ColXML AS XML) to determine which value(s) cannot be converted to XML, and then seeing if there are any obvious characters in those values that could be causing the problem?

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA