>>CREATE TABLE SORTTEST (SKNO N(4)) >>INSERT INTO SORTTEST VALUES (250) >>INSERT INTO SORTTEST VALUES (350) >>INSERT INTO SORTTEST VALUES (6300) >>INSERT INTO SORTTEST VALUES (650) >>INSERT INTO SORTTEST VALUES (60) >>INDEX ON SKNO TAG SKNO >>INDEX ON STR(SKNO,4) TAG SKNOZ >>INDEX ON PADR(TRANSFORM(SKNO),4) TAG SKNOA >> >>** When I need to do an incremental search. >>nUserinput = 6 >> >>SET ORDER TO sknoZ >>= SEEK(STR(nUserinput, 4)) ; >> OR SEEK(STR(nUserinput, 3)) ; >> OR SEEK(STR(nUserinput, 2)) ; >> OR SEEK(STR(nUserinput, 1)) >> >>SET ORDER TO sknoA >>>>