>>This should be a no brainer, but I can't get the syntax correct.
>>
>>Any Ideas out there???
>>
>>thanks, Vince
>
>What are the types of the fields? If both are character, it's actually a bit tricky, though Fabio proposed a great solution a while back.

I meant Re: Creating a compound index with a descending portion Thread #1053896 Message #1054185 and the whole thread.