hi
i have a table that has time column in the format hh:mm am/pm ie 10:00 AM
but it is varchar type
i need to sort the rows by the time
ie 12:00 Am-12:00 Pm -11:30 Pm
could someone tell me as to how to do this only with mysql statements
regards
Narayanan
