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)