Gavin Scott writes:

>I wonder how many databases still use YYMMDD date formats (i.e. with date
>windowing) and have fields of this type as sort items?

The answer is probably, "not many" -- and for the most part, the fix is
to remove the sort on the path. The reason is that paths sorted on YYMMDD
and intended to provide date-sorted retrievals will give wrong answers
anyway. So either the date field has to be changed, or inquiry programs
have to do their own sorting. If the latter path is chosen, the sort can
be removed.

-- Bruce


--------------------------------------------------------------------------
Bruce Toback    Tel: (602) 996-8601| My candle burns at both ends;
OPT, Inc.            (800) 858-4507| It will not last the night;
11801 N. Tatum Blvd. Ste. 142      | But ah, my foes, and oh, my friends -
Phoenix AZ 85028                   | It gives a lovely light.
btoback AT optc.com                |     -- Edna St. Vincent Millay
Mail sent to [log in to unmask] will be inspected for a
fee of US$250. Mailing to said address constitutes agreement to
pay, including collection costs.