still sorting and casting problems

Hello there

Unfortunately, I can't change the fieldtype that easy because other
applications use the date as char(10) field as well.

I need to sort the query by the log_date desc (log_date is char(10)). I
tried the following without success :

select id, log_date from userlog order by cast (log_date as date) desc

select id, log_date from userlog order by date(log_date) desc

Please help and thank's in advance ... jr

__________________________________________________

PFISTER + PARTNER, SYSTEM - ENGINEERING AG
Juerg Rietmann
Grundstrasse 22a
6343 Rotkreuz
Switzerland

internet : www.pup.ch
phone : +4141 790 4040
fax : +4141 790 2545
mobile : +4179 211 0315
__________________________________________________