I#%92m working with SQL 2005 and the new T-SQL for XML. Does anyone know how to return the â€œmultipleâ€ values with some kind of delimiter or return them by Rows? Below is my Query. Currently I get 10 ASIN numbers on a single row seperated by a space. Select top 1 XMLData.query('declare default element namespace "http://webservices.amazon.com/AWSECommerceService/2004-11-10"; data(/ItemSearchResponse/Items/Item/ASIN)') ASIN From XMLDATA Thank you.