>>>>>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 could use IS, but apparently that has its own problems, are there any other options?
>
>It's hard to answer your question w/o knowing what you're doing. :)

Array of primary keys needs to return array of BusinessObject, so rather than fire off say, a 1000 individual SELECTs I want to execute the entire query in one swoop to improve performance.

Kev