>I need to create a composed index !
>
>The first part DESC an the second part of the index ASC
>
>
>Example :
>
> index on fields1 ASC + (fields2 + fields3 desc)
I think this is not possible. You can only specify one arrangement in one index expression. It's either ASCENDING or DESCENDING.
If you don't mind, what's your objective why you need to have that kind of index?
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net
CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."