11-14-2004, 05:20 AM
Quote:I suppose if the sorting column were alphanumeric, you would be better off "subtracting" it from a string of CHR$(255)'s. For each character "x" in the string, replace it with CHR$(255-ASC("x")) in the sortkey.MEG: Forgive me. In my last post I was so excited with the fact the Neo came up with the XOR solution, that I neglected to acknowledge your equally elegant solution with has exactly the same effect using arithmetic instead of the XOR bit-wise logic.
*peace*
Meg.
I consider that both you and Neo are the co-winners of the challenge by demonstrating that manipulation of the sort key can solve an otherwise sticky sorting problem. Hurrah to you both.