>>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?

Not really serious. My last paragraph of that post was me talking myself out of it, although I could have been more convincing:

..but then again David's suggestion using INSERT INTO...SELECT FROM also solves this problem as long as what you are inserting into has the (compatible) data type structure you want. Hmmm, maybe forget the ER and all this... < g >