I need to select record from a table in my database.the table field has a varchar type that holds date data.I want the records to be displayed according to the date selected by the user desc.The problem is that the record displays only data by the day and not by month.i want a chronological display of data.

Select whatever Order By Format(DateField, 'mm-dd-yyyy') I think will do it.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=75125

Haven't tried this specific method myself, but I have used convert in the past and it has worked for me.