>I do see your point on this precedence since we now have an Integer in the first SELECT and a numeric in the second SELECT, but since a CAST was used in the first one, let that take the precedence. If no CAST was used, default back to the original UNION precedence.
>
>Oh well, maybe an ER for VFP 10...
>

Hi Mark,

Are you serious?
What if CAST is used in the second SELECT too, but with different data type?
Or let's say the first SELECT doesn't use CAST, but third and fifth do. Does any of them take precedence? Which one?

Let's get real. The CAST function affects result of the SELECT it is used in. UNION combines results, it doesn't care how you end up with the integer field in one of them. If you want to force the data type and UNION data type precedence doesn't work for you, force it for every SELECT in UNION.

Thanks,
Aleksey.