On Wed, Jul 3, 2019 at 12:48 PM Gene Wirchenko gene@shaw.ca wrote:

  What if an index is not appropriate?  Is there any way to do a

LOCATE backwards (or something equivalent)? (The table has 186,574 rows currently so searching backwards would definitely be worth it.) I do not think there is such a critter, but maybe, you know better?

SET FILTER TO <condition> && optional GO BOTTOM SKIP -1 && as needed, this LOCATEs backwards