I have a field for Order Detail Number wich has the format YYMM-OOOO-X-XX where YY are last digits of year, MM is month, OOOO - Order Number, X - Type of Order, XX - Number of Detail. By Y2K I could use ORDER BY OrderDetailNumber DESC to display records in appropriate order. Now it doesn't work anymore. Any ideas how to sort this kind of data to display records in descending order ?
I have OrderDetailID (auto increment), but I cannot use it because Order Details might be entered for old order, so they will not be groupped by order.
Thank you
Vlad