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.
Jim Nelson
Newbury Park, CA