SELECT * FROM bank ORDER BY bankname INTO table bbank SELECT banks ZAP APPEND FROM DBF("bbnks") && this will change natural sort order select banks set order to go top aa=1 do while !eof() replace code with aa && code is changed according to bank alphabetic sort order skip aa=aa+1 loop ENDDO