People, I am not very savy with SQL and I need help. I have a char field that contains a date and the date is in DD-MM-YYYY and I want to sort it but the sort is wrong because 01-04-2007 comes out before 10-22-2006.
Is there an easy way to provide a correct sorted output list or do I need to edit my table and convert all my fields to YYYY-MM-DD before I can sort it. Any help is welcome. Thanks, Néstor :-)
