Carl,

Add another field for sort purposes, you may have to make "AA" longer so the UNION won't bomb. Something like:

>

>select sccdesc as col1, scccode,  ;
     sccdesc as sortField ;
>    from choice where scctype = "STATENUM";
>    into array thisform.lastates;
>    union select " All States" as col1, "  " as scccode, ;
          "AA" as sortField ;
>    from choice  order by sortField
>
>this.rowsource = "thisform.lastates"

>
>thank you in advance
>Carl <><