>I was afraid you'd say that.
>
>I tried that on my first attempt, but my "IN string" ends up being too long. The IN field is 17 chars long and there can be any number of them. I came up with one "normal" instance where there are 65 items in the IN list.
>
>My query crashed with an error that the query is too complicated(or something similar).
>
>Any ideas for properly deleting the temp table?
>
>I REALLY appreciate your suggestions and time.
>
>

You could put this all in a VFP COM component and manipulate the data with native VFP commands. COM components are faster than interpreted VBScript. The COM component could return an ADO recordset if needed.

Make sure you mark your COM component as "multithreaded DLL".