>SELECT ..., > IIF(LEFT(contact,1) >= "A", "1", "2") AS cord ; > ORDER BY cord, contact > ...>
>> Select contact, eligarea, groupnum, groupname, ; >> IIF(ASC(contact)>64, ASC(contact)-48,ASC(contact)) as contactord from modicomm ; >> WHERE NOT DELETED() ORDER BY contactord INTO CURSOR TempC >> SELECT contact, eligarea, groupnum, groupname FROM TempC INTO CURSOR Temp >> Select Temp >> Copy to C:\Temp\vsamnew.txt Type SDF >>>>