On Monday 29 September 2003 12:26, Bjørn T Johansen wrote:
> The problem is that I don't have such a "period". I can have a select
> containing these data:
>
> 2350
> 0110
> 0330
>
> which then should be sorted like that.
>
> And I can also have the following:
>
> 1030
> 1145
> 1240
>
> (also sorted as shown...)
>
> the only thing I know for sure, is that the interval between the first
> record and the last, is always less than 24 hours...
And how do you know that the first example shouldn't have been
0110
0330
2350
--
Richard Huxton
Archonet Ltd