Converting a field or converting a date?

2006-12-05 Thread 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- 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

Re: Converting a field or converting a date?

2006-12-05 Thread Dan Nelson
In the last episode (Dec 05), Nstor said: 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- 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