Subject Re: order-by problem
Author Adam
--- In, "martinknappe" <martin@...>
> See the logic I was following was this: Remember the code of the sp?
> It went:
> for select first 20 id, asterm from
> dicentries
> where asterm = :astermin and id <= :idin
> order by asterm descending, id descending
> into idout, astermout
> The 20 records are fetched from back to front (order by asterm

That is not true.

They are ordered by their ordinal value in descending order.

z - a then Z to A

You seem to be expecting a case insensitive sort, which you will not
get unless you define such a collation or use the upper.