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)