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.