Hi Peter,

You can probably do this *without* the array.

Assuming this was the "first" SELECT statement you performed programmatically:

SELECT FROM SomeTable WHERE SomeCondition

then you could do something like this:

SELECT ;
FROM MyTable ;
WHERE MyField IN ;
( SELECT FROM SomeTable WHERE SomeCondition )

HTH,
Evan Pauley

>From MyTable I programmatically perform a select. I then copy one field in that query to a one dimensional array that can be anywhere from six to four thousand rows. What I want to do now is to perform a different select using only the records that match those from the array. The syntax should be SELECT * FROM MYTABLE WHERE MYFIELD =... and then what?

Evan Pauley, MCP
Positronic Technology Systems LLC
Knoxville, TN

If a vegetarian eats vegetables, what does a humanitarian eat?