thanks Hugo. It looks like it should work, I get it, but I am still left with the same order as a normal index.
must be missing something.
k
>Not that I recommend it, but you could do:
>
>
>index on iif(left(myfield, 1) = '/', myfield + space(1), '?' + myfield) tag mywierdindex
>
>
>So if myfield starts with a slash we add a space to the end of the string, if it is not we add a question mark (or any other character whose ASCII value is greater than the ASCII value of the slash) at the beginning (the space is added so both strings have the same length)
>
>But I think you should look into other solutions.