• SELECT PrimaryKeyColumn, TRY_CONVERT(xml, VarcharColumn) AS XMLValue, VarcharColumn
    FROM YourTable
    WHERE TRY_CONVERT(xml, VarcharColumn) IS NULL
        AND VarcharColumn IS NOT NULL;

    This should identify the problem rows.

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)