I had this just yesterday. The same union works in SQL. I found that it's the field size that was killing my union - once I made both queries with the same size results it worked.
>>That's what I meant. Reviewing your original query, I see that you have the larger one first. I thought you had the wrong order. Sorry.
>>
>>But, right now I do a simple test on my data, which reveals that at least for character data, I
can not combine characters of different lengths, whatever the order. (Using VFP 6.) I think you should try to make them the same length.
>
>Ok, I couldn't get it to work either. At least I'm not losing my mind! :-)