[thelist] select

[Scott Dexter]

what is the datatype of the field?

if its a datetime datatype, there's no problem:

select ... from ... where ... order by datefield

if you don't have it in the database as a date datatype, yer, um, pooched.
Time to convert the field....

sgd
--
work: http://www.ti3.com/
non: http://thinksafely.org/

> -----Original Message-----
> From: Andrew Martin [mailto:comitque at hotmail.com]
> 
> is there to get the results of a sql query to sort by actual 
> date instead
> of numbered date?  for instance, right now it will give:
> 
> 1/12/2000
> 12/03/2000
> 7/06/2000
> 9/04/2000
> 
> instead of:
> 
> 1/12/2000
> 7/06/2000
> 9/04/2000
> 12/03/2000
> 
> any suggestions?  btw, i'm using asp if that makes a 
> difference...  thanks!