Subject Re: [IBO] Sorting
This is not an IBO problem. It is a general SQL problem.

There are a number of ways around it depending on the particular

The simplest solution is to only save the field as Upper case.

A refinement on that is to ensure that the first character is always
upper case.

If this is not acceptable, then things start to get a little crafty.
Create a BEFORE INSERT trigger that creates a second upper case version
of the field and use that for ordering.

We then get into even more complex areas with collation order etc. but I
have not needed to go there yet.

( Creating index number lists in the right order is fun, but is it
really a problem to start at INV100000 instead of INV000000 )

Lester Caine
L.S.Caine Electronic Services