Hi,

We used to do the following before we moved to SPT with SQL backend:

SELECT MyItemTable
SET ORDER TO MyOrder
SEEK MyItem
SCAN WHILE {condition}
   {...}
ENDSCAN

HTH,
Arriyel

>Hi toall,
>
>i have a table1 with an index 'item', my problem is how seek all items starting in 4th position to the 8th positon without changing my index?
>e.g
>abc14421xyz01
>i need to seek all 1442 using seek statement and not select statement.
>please help.
>tia
>Ryan.