I am building a combo box with state code and state name,
I am forcing "all states" into the array,
I would like for "All States" to be first in the list with all the other states alphabetically without placing a space as the first character.
Below is my select statement which works fine:(but i'm forced to put a space in for it to be first)
select sccdesc as col1, scccode ;
from choice where scctype = "STATENUM";
into array thisform.lastates;
union select " All States" as col1, " " as scccode;
from choice order by col1
this.rowsource = "thisform.lastates"
thank you in advance
Carl <><
For God so loved the world that he gave his one and only Son, that whoever believes in him shall not perish but have eternal life. John 3:16