>Thank you Craig. Thats the way he is currently doing it. We are just looking into switching from 2.6 to 7 and he was wondering if there was a better way to do it in the new version.
Yes, use a view, it can have the "order by" clause with DESC or ASCE subclauses for each expression in the list. Frankly, whenever I see a complex index expression, I usually feel there's a way to live without it, and start investigating the reasons why would we use such a thing at all. I remember I was using such indexes for reporting purposes, or to ease some searches - and dropped them one by one as I was learning SQL. It eventually turned out that a well thought set of one-field tags and SQL Selects whenever you need them were easier to maintain, and faster to run than complex indexes.
Of course, you will know your data better than I can ever know them, so you're the only one to judge the reason of existence of such an index.