>Looks like a bug to me because VFP certanly can determine the field type from the first select in the UNION.
Let me check it in VFP9 now. It gives the same error, but the name of the column is displayed correctly in VFP9. In VFP8 it gives some weird chars...
If it's not broken, fix it until it is.
My Blog 
