CLEAR CREATE CURSOR pippo ( cc C(2)) INDEX ON cc TAG singleTag * First char of CC is a group marker, second is a subgroup marker SET MULTILOCK ON =CURSORSETPROP("Buffering",5) INSERT INTO pippo VALUES ('A2') INSERT INTO pippo VALUES ('A1') INSERT INTO pippo VALUES ('A3') INSERT INTO pippo VALUES ('C2') INSERT INTO pippo VALUES ('C1') INSERT INTO pippo VALUES ('C5') INSERT INTO pippo VALUES ('C4') INSERT INTO pippo VALUES ('B5') INSERT INTO pippo VALUES ('B2') INSERT INTO pippo VALUES ('B1') INSERT INTO pippo VALUES ('B7') INSERT INTO pippo VALUES ('B6') * You want extract the big subgroup for any group, in group ascending order: * A3 * B7 * C5 * With SEEK you can implement a very fast solution, SELECT pippo SET ORDER TO singleTag SET NEAR ON SCAN && you want go to the last item of LEFT(cc,1) group SEEK LEFT(cc,1)+CHR(255) ORDER singleTag DESCENDING ? CC ENDSCAN SET NEAR OFFThe only other solution, without use SEEK DESC, have to scan all records.