View Full Version : How to order by date inselect statement using Microsoft SQL query

06-27-2002, 09:59 AM

I would like to do a SELECT query statement from a table and would like to order the records based on date field in the table.
How can I do it using Microsoft SQL?

For example:

Select * from MMPODT order by keyval3(date's field name)

The date field's data type is character and it is displayed as 20020625 (yyyymmdd)