Thank you Sergey,

Your method may just be the shortest code available.

Tracy

>Hi Tracy,
>
>It could be slow if your table is big. I would rather use SEEK()

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

>
>>Here's a thought how much speed loss do you think I would get with this.
><snip>