...

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



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)



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum