SQL sort question

[william humphrey]

I have been using "ORDER BY" to sort a field which has dates in the format
yyyy-mm-dd for years now and just today it sorts it like this (with "ORDER
BY DESC):

2006-02-15
2005-03-15
2013-01-24
2012-05-17
2012-05-10

What is going on?

I tested other sorts including recID and they work. Also that weird sort is
not dependent on recID

The above should have sorted:

2013-01-24
2012-05-17
2012-05-10
2006-02-15
2005-03-15
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20130226/8fd79f8f/attachment.html>