From: chris.sjpd@gmail.com   
      
   On Wednesday, June 10, 2020 at 2:42:09 PM UTC-7, Erland Sommarskog wrote:   
   > chris H (chris.sjpd@gmail.com) writes:   
   > > Thank you for the suggestion.  The codes do not error out anymore;   
   > > however, it does not give me the value.  Am I missing something?   
   > >   
   > > SELECT *   
   > > FROM OPENXML(@hDoc, '/Agency', 1)   
   > >   
   >   
   >   
   > What does your full XML document look like? What you posted, is just a bunch   
   > of unrelated element with no root tag. I assume the full document is longer.   
      
   Hi Erland,   
      
   That is a complete xml file.  When I doubleclick to open it, it does not have   
   root tag.   
      
   Thanks,   
   Chris   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)