Subject Re: Change sort order to some custom logic
Author mircostange
> I think that the only way you can get these values to sort in
a "numerical"
> sequence is to store them that way: '0001', '0010', etc.
>

which unfortunately isn't possible. The restriction is not to alter
the contents of the tables. In general, "1" and "01" may well occur
but should be distinct values (I know it's crazy...)
>

> I'm not familiar with this method; but AFAIK, IBO *always* needs
to use an
> ORDER BY clause to sort datasets, doesn't it?
>
That's what I thought, but I was playing with the CompareText option
to allow case-insensitive incremental searching. An IBO inc search is
somehow linked with ordering, so why does this work?

Mirco