Hi Eric,

This works for me

select * from openxml 
  (@idoc, '/ArrayOfString/string', 2) WITH ([string]  char(16) '../string')

>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?
>
>