From: chris.sjpd@gmail.com   
      
   Hi Erland,   
      
   When I run the below query, it has no errors but returns no data. Could you   
   please take a look at my query & let me know what I'm missing?  Appreciate   
   your helps very much.   
      
   SELECT Agency.a.value('(AccidentReportNumber-AllPages/text())[1]',   
   'varchar(20)') AS [AccidentReportNumber],   
          Vehicle.v.value('(Make/text())[1]', 'varchar(20)') AS [Make],	   
   	Myrole.r.value('(TrafficUnitDriverCheck/text())[1]', 'nvarchar(10)') AS   
   [Driver],	   
   	Myrole.r.value('(SobrietyDrugPhysicalA/text())[1]', 'varchar(20)') AS   
   [Sobriety_Drug_Physical_A]   
   	   
    FROM xmltbl   
    CROSS APPLY xmlcontent.nodes('/agency') AS Agency(a)   
    CROSS  APPLY Agency.a.nodes('TrafficUnit[TrafficUnit_Number="2"]/Driver') AS   
   Driver(d)   
    CROSS APPLY Agency.a.nodes('TrafficUnit/TrafficUnit_Number/Driver/Vehicle')   
   AS Vehicle(v)   
    CROSS APPLY Agency.a.nodes('/TrafficUnit') AS Myrole(r)   
      
   Thank you,   
   Chris   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)