Thanks, that looped nicely:

select * from mda320_results as mda320_results1 left join mda320_results as mda320_results2

on mda320_results2.counter = mda320_results1.counter + 1

where mda320_results2.digi1 < mda320_results1.digi1

while @@rowcount > 0

then my update query

OK

I've gotton this far which updates the each row where digi1 value is less than the previous digi1 value.

update mda320_results2

set digi1=mda320_results2.digi1+65535

from mda320_results as mda320_results1 left join mda320_results as mda320_results2

on mda320_results2.RowID...