>Naomi,
>
>The original problem was Dorris could not get a sorting correct with sorting fielda descending + fieldb ascending + fieldc ascending, plus an extra the complication was a udf and a double use of the same local variable.
>
>Regards,
>
>Koen
I see. My former colleague had similar problem with the indexes and complex sort. I believe you had this requirement before as well.
If it's not broken, fix it until it is.
My Blog