I figured it out. I have to alltrim the memo fields first to make it work.

>I don't want the results of doing a "union all" since it causes
>duplicate records to show. I am forced to use it to include my
>memo fields however. Is there anything I can do?