Subject | Re: Change sort order to some custom logic |
---|---|
Author | mircostange |
Post date | 2002-06-10T10:41:53Z |
> I think that the only way you can get these values to sort ina "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...)
>to use an
> I'm not familiar with this method; but AFAIK, IBO *always* needs
> 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