>>>Kevin,
>>>
>>>> the SQL consists of 1000's of UNION selects
>>>
>>>You need a serious redesign of that query!
>>
>>Unfortunately it's a generated query, typically when we perform searches against the database we just return the primary key's to save time, then if necessary the records are fetched in whole.
>>
>It still doesn't explain why you need 1000's UNIONs. :)

I meant IN, not IS :)