Asif- Thanks for that, nice solution! I was going down a similar path when I realized that the day portion of the file name wasn't written with leading zeros in the case of a single digit day and decided the files needed to be renamed for sanity's sake. Your solution is what I originally had in mind though, so thanks for fleshing it out! I'll store it away just in case. Regards, Ron > Ron, > > This is an interesting problem indeed. If the month is > always characters 4 to 6 then I have a solution that > will fix half of your problem. > > Create a new table called something like > month_id(month_name, id) and populate with values like > > > month_name id > Jan 1 > Feb 2 > Mar 3 > Apr 4 > > Now a SQL statement like the following will sort the > files by month. > > SELECT d.crazydate > FROM date_test d, month_id m > WHERE m.month_name = RIGHT(LEFT(d.crazydate, 6), 3) > ORDER BY m.id > > The date part could be solved with a similar approach > I think. Will let you know if I figure it out.