im trying to get the following code to work.. but it just keeps returning the first row...

declare @spXML as varchar(1000) 
set @spXML = '<ArrayOfString>
  <string>0002A5FF6ECC</string>  
  <string>000393ED2634</string>  
  <string>000A95895CE4</string>  
  <string>000BCD022EAE</string>  
  <string>000D28975D26</string>  
  <string>00508BFBE766</string>  
  <string>0090F514003C</string>
  </ArrayOfString>'

DECLARE @idoc int 
EXEC sp_xml_preparedocument @idoc OUTPUT, @spXML 
select * from openxml (@idoc, '/ArrayOfString', 2) WITH ([string]  char(16))

any ideas?

Eric