• Nice question. XML is one part of the database I am still struggling with. I first ticked the answer I thought was corerct without submitting, then went to the dosumentation to double check - and was relieved to find that my first idea was indeed correct. 🙂

    Oh, and Ron --- you might need to adjust your sarcasm detector; it's malfunctioning 😛


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/