>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 >>