Hi Eric,

Yes it does returnin the first value in all rows, sorry. Here's fixed version that does return correct values.

 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/string', 2) WITH (string  char(16) '.')

>I just tried this and its returning all the same values...
>
>>Hi Eric,