Tim --
Hmmmm...maybe the first part of the query is setting up a temp table where nulls are not allowed, huh? How about substituting NVL(fieldname,SPACE(20)) and the like for those columns in the SQL statement that may be NULL? (Substitute SPACE(20) for whatever the type/length equiv would be to keep the UNION valid).
>>Try SET NULL ON and/or SET NULLDISPLAY TO "".
>
>I tried it, and it did not work. Thanks for the suggestion! I hope you have more. :)
>
>I guess I could scrap the LEFT OUTER JOIN and go back to the old way of handling outer joins, that is, NOT EXISTS (subquery) or value NOT IN (sub query). I would rather not, since it looks like the LEFT OUTER JOIN syntax runs faster.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05