Thank you very much / Jim


>Sorry, my fault: with UNION the order statement needs the column number, not name:
>
>... order by 1
>
>
>>That seems to work -- if I don't use the order by clause. I get an error squawk if I do use it.
>>
>>
>>
>>>I have a combobox in a grid with RowSourceType = 3, and the following RowSource:
>>>

select partno, descript from PartsList where empty(Prodalias) into cursor TempCombo order by partno

>>>Is there some way to insert a blank row into the beginning of this cursor as part of this statement?
>>>
>>>

>>>SELECT [ -- None -- ] AS partno, [ -- Not Applicable -- ] AS descript FROM PartsList UNION SELECT partno, descript from PartsList where empty(Prodalias) into cursor TempCombo order by partno
>>>

>>>
>>>You just need to be sure that you use PADR() to make sure that the fields are the same length in both parts of the UNION.