You could also build an In clause in VFP with your array and use that in the SPT.
EX.
FOR I = 1 TO ALEN(myArray)
lcInClause = lcInClause + "'" + myArray(I) "'" + ","
ENDFOR
lcInClause = SUBSTR(lcInClause,1,LEN(lcInClause) - 1) && remove extra comma
=sqlexec(handle, "select * from ... where field in(&lcInClause)","mycursor")
>>
>>The server can't execute this; that'd have to be executed locally rather than remotely because your memory space is not visible to it. You'd need to dump the array into a cursor on the backend and use an IN clause in the WHERE clause.
>
>How to create a cursor on backend?
>Thanks
>Ed
(On an infant's shirt): Already smarter than Bush