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 c

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 e