Ordering days in a weekly format

[truezplaya]

i have a tree view that reads in data from a database and allows you to select the year, the programme then populates the weeks you select a week , and then it populates the days within that week from the db. . The issue i am having is ordering these in to monday tuesday wensday etc etc(weekly format). Has anyone got any ideas how i could attempt this

Please note not all weeks have all 7 days and i am using VB.net

Cheers in advanced

Truez

[kadghar]

if you dont mind adding an extra column, write in a new column the day using WEEKDAY function.

then only sort the db with that column.

HTH

[truezplaya]

I am looking for a solution that doesn't involve altering the DB in any shape or form. Thanks for the reply

[truezplaya]

I have found a way i have just done several SQL statements specifically picking a distinc single day at a time any questions about this please post