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.