>Hi Aleksey:
>
>Just one other thing. Do you have any insight into why this occurs in VFP8 and not in VFP7 given that this behaviour is not a documented changed (as far as I can see <s>).
>
>Thanks.

Hi Gary,

The behavior of the UNION operation is changed in VFP8, data types returned by the second, third and ... SELECT statements affect final data types (I believe, it is documented). It doesn't work this way in VFP7.

Thanks,
Aleksey.