>Native data Senario.
>localcur
>select somefields from mytable where mytable.keyfield in (select keyfield from localcur)
>the above works fine with native VFP data.
>
>SQL data senario
>localcur
>*** the localcur can not be used in SQLEXEC, therefore i populate the data into an array:
>select keyfield from localcur into array myarray
>Is there an SQL syntax similar to:
>sqlexec(lhandle,[select somefields form mytable where myrable.keyfield in myarray)
>Please note: I would like to avoid the creation of a string with data from the array.

Nope, you can't do that.
But you can create an SQL query that would return you the same results using only SQL Server tables.