sql speed

[jda]

>  Yes, something like this:
>  >
>>  select RecID from thereferences where (left(allFields, 3)='the')
>
>Excellent, so solution is:
>
>
>select id,hit,uniqueID,authors,thedate,title,editors,authorsSortMethod
>from thereferences
>where RecID in
>         ( select RecID from thereferences where (left(allFields, 3)='the'))
>

No. You don't understand (or I don't). That is only one search. I do 
MANY searches in a loop, after each one adding to my integer array 
(or recids). That way I can AND or OR many searches myself.

When I am finished I want to turn that array of recids I have made 
into a cursor.

Jon