[thelist] sorting recordset problems

[Pringle, Ron]

> Off the top of my head:
> 
>  * sorting in VBScript can be a nightmare
>  * can you sort your query by a substring of the file name, or by two
> substrings?
>  * for the month, you'd also have to include a CASE statement so you
> could sort descending on the number of the month. There's no 
> logical way
> to sort the names of the months.
> 
> Anywhere I'm allowed (and some places I'm not) I enforce 
> CCYYMMDD dates
> exclusively, to sorting is simple and conversion to other formats
> relatively simple.
> 
> joel

Joel-

Thanks for the response. Yes, I'm thinking I may need to rewrite the file
names, as it'd be a hell of a lot easier, however, there are thousands of
these files already in existence from before my time. I think I'll approach
it that way though, as I'm sure it will save me down the road.

Ron