Tracy,

You're welcome.

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