Michel,

VFP8 doesn't allow memo or general field in UNION. Would UNION ALL work for you in this case? It doesn't have such restriction.

>Here's another weird issue with the use of ANSI SQL in VFP 8. The following command:
>
>

>SELECT New.Message FROM New WHERE New.Type=2;
>UNION;
>SELECT New.Message FROM New WHERE New.Type=16
>

>
>generate operation is invalid for a memo field. New.Message is a memo field but what exactly is the problem?
>
>This was part of a bigger SQL. I squeezed it down to this format.