Excellent, thanks Jaime.

>Caroline
>Try

>lnFields = allt(str(fcount("DirectAddress")))
>
>Select DirectAddress.*, .T. as Direct, nSSC as Code;
>from DirectAddress;
>union select ResidueAddress.*, .F., Residue;
>from ResidueAddress;
>order by &lnFields desc;
>into Cursor AddressOrder nofilter
>

>HTH
>Jaime
>
>>I'm doing a Union with 2 identical tables and I'm trying to order be some additional fields that I'm adding. However if I put a variable as the field number to order by I get an error.
>>Could someone please help.
>>

>>lnFields = fcount("DirectAddress")
>>
>>Select DirectAddress.*, .T. as Direct, nSSC as Code;
>>from DirectAddress;
>>union select ResidueAddress.*, .F., Residue;
>>from ResidueAddress;
>>order by Evaluate(lnFields) desc;
>>into Cursor AddressOrder nofilter
>>

>>Thanks in anticipation.