Mr. GSquared,
Thanks for the prompt response. However, I expected 2 rows in the result set. I dont understand where the other row disappeared to. Just to make it clear, the source of the xml data would be a column in another table/query. So the number of rows in that column would vary, and I need all the data in the rows to be used. I hope I make sense!!