>Bob,
>I have done that before :) If you need evidence a simple one :
>
>

>CREATE PROCEDURE Cusdetails @cCustomerID nchar(5) AS
>SELECT Customers.CustomerID, ContactName, CompanyName,
>       Orders.OrderID, OrderDate
>FROM Customers, Orders
>WHERE Customers.CustomerID = Orders.CustomerID
>AND Customers.CustomerID = @cCustomerID
>ORDER BY Orders.OrderID
>FOR XML AUTO
>GO
>
>
>lnHandle = ...
>m.customerID = 'BONAP'
>SQLExec(lnHandle, 'Exec CusDetails ?customerID','SPResult')
>

Returns just one row with one field.
>Cetin

Ok... well, you are only getting one record, and it may all fit into on field in one row. Take out the AND so you get ALL records and see what you get.

BOb