SELECT TheTable SET ORDER TO Whatever DESCENDING LOCATE FOR YourCriteria REST SET ORDER TO Whatever ASCENDINGIf needed you could create an index for the order you want these records in so you can take advantage of the descending/ascending features of the index order.