>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 try to use the instruction index on, but i don't find the good syntaxe !
>
>Can we help me please !
>
>Thanks !!
It can be done, but the solution depends on the data types of the fields.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer