Converting a field or converting a date?

[Néstor]

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 :-)