>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.
Cool. I think I'm starting understand how it works now. Thanks.
Roi
'MCP' Visual FoxPro
In Rome, there was a poem.
About a dog, who found two bone.
He lick the one, he lick the other.
He went pyscho, he drop dead!