SET EXACT OFF SEEK transform(13609,'99999999') SCAN WHILE transform(de_sysnum,'99999999')+transform(de_histnum,'9999') = transform(13609,'99999999'); FOR de_sysnum == 13609 **** Do something ENDSCAN...
SET EXACT OFF SEEK transform(13609,'99999999') SET EXACT ON SCAN rest WHILE de_sysnum = 13609 **** Do something ENDSCANSince the controlling index already forces the order. Am I overlooking something ?