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?