date conversaion sorting help

[Bell1991]

I have a table that has has a date column but is varchar(20)... This table has 2008/2009 data in in.

How do i sort by date

I have tried:
SELECT convert(varchar,Date,101) FROM autoissuelogdate
order by convert(varchar,Date,101) desc

but that returned 12/31/08 at the top of the list...

Any siggestions (other than changing the column type)?

Thanks in advance and happy new year!

 

[gmmastros]

You can try...

order by convert(DateTime,YourDateColumn,101) desc

This code will fail if you have varchar data that cannot be converted to a proper date time.



-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[Bell1991]

Perfect! Thanks!