just to clarify... it's a text field not date/time? so you'd be looking at string manip to do it?
-----Original Message----- From: Knott, Brian Sent: Thursday, 29 May 2003 9:32 AM To: CFAussie Mailing List Subject: [cfaussie] Sorting by 24 hr time Does anyone know how to sort a query based on a 24 hour time. The field in question is a test field not time field. At the moment it is sorting like this 13:00 06:00 10:00 11:00 Mot sure why it want to put 13:00 above the rest Brian Knott QANTM Studio Senior Database Developer Ph (07) 30174331 Mob 0407572127 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
