Hilmar

>It seems it is the last SELECT statement that takes too long, right?
>
>Do you have indices on the most important expressions?

Yes I have the table indexed (see line 2)

>>Select RZSTOP
>>Set Order To RGDSNum && RTE_NO+RTE_LET+DIRECTN+STR(SEQNO,4)+STR(NUMBER,3)

>It might help if you have an index on fields that take many different values. It might also help if you >DON'T have an index on fields that take only a few values, nor on DELETED().

Well, as there could be many J rec's with the same RTE_NO + RTE_LET + DIRECTN (c.f. Composite PK), but, of course, incrementally differnnet SEQNOs, do you mean I should knock off the PK?

Apart from that I would seem to comply with your ideas.

Terry