>>>>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. :)