therry
06-27-2002, 08:59 AM
Hi,
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)
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)