On Tue, 2003-09-30 at 10:42, Richard Huxton wrote: > So - your rule is something like: > > For some block of times... > IF max(my_time) - min(my_time) > 12 hours > THEN sort "through midnight" > ELSE sort "naturally" > > Which is what Tom said (I was wondering where he got his 12 hours from). > Have I got that right?
Yes, that sounds about right.. :) But how do I code this in an Select statement? BTJ ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly