PADR(TRANSFORM(numfld),4)will bring me to the 6300 before the 650. I believe I have the answer to the seek now. I'll have to index
PADL(TRANSFORM(numfld),4,"0")Then seek on according to what Sergey suggested.
INDEX ON PADL(TRANSFORM(numfld),4,"0") INDEX ON PADL(numfld,4,"0") INDEX ON numfld INDEX ON STR(numfld,4)all sort records in the same order.