Hilmar

You might be interested in the following comparison

The database being scanned has 50 fields so records sizes are quite large
approx 59000 records

The following code took 18 seconds

select globalnew
set order to tag created
go top
scan for accountno=accountno
endscan

The following code took 1 second

select globalnew
set order to tag created
go top
scan while accountno=accountno
endscan

An enormous difference - is this because Rushmore gets invoved in the firsr example?

Colin