I am using a SELECT query to drag out records sorted by WEEKDAY. The trouble is, they sort themselves alphabetically (naturally) and this looks a bit stupid when Friday is the "first" day. Is there a way to sort by actual weekday order?
Code I am using is:
"SELECT * FROM FLIGHTS ORDER BY 'intdom', 'day' ASC"
where "day" is the weekday field.