Sergey,

How would I accomplish this table merge in VFP8? I don't want to write something now that will break in a few months when VFP8 comes out.

Thanks,

TFISHER

>>Your error from the Union of the two memo fields most likely is due to different Memo Blocksizes for the two tables. If you get a chance, would you check this theory. Thanks.
>
>Nope. The error is generated because UNION requires VFP to do DISTINCT on the records in the result set but VFP doesn't compare MEMO/GENERAL fields in DISTINCT operation and there are no other fields to compare. In VFP8 you cannot include Memo/General fields in UNION select even with other fields.