>>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! :-)

In addition to my previous messages, the following works too (structure: ArtCode C(8), ArtName C(30)):

select ArtCode from ArticleMain;
	union select padr(ArtName,30) from ArticleMain

However, as the H.G. suggests, the first part of the union is used as a template, and the fields are truncated to the smaller size.

Again, note that in the second part I converted the field to a not-only-field expression, to force VFP to accept it.

Hilmar.