What a coincidence... I need to do this today too. Is this method available in SQL Server 2000? If I remember correctly, sp_xml_preparedocument is only a SQL 2005 procedure.

>You can use XML to pass list of values into SP. See Re: Sending a list from vfp Message #829213
>
>>How do I send parameter to a stored procedure which expands to ['222','333']
>>

>>create procedure getMyVal @cPara varchar(50)
>>as
>>select * from <ctable> where id in (@cPara)
>>

>>calling
>>

>>cPara= "'222','333'"
>>sqlexec(nHandle,"exec getMyVal ?cPara")
>>

>>I am not able to send an InList equivalent string to SQLserver SP. I want the parameter to contain something like '222','333' so that IN Clause works on multiple values.
>>Can it work? Is there another way?