Hi guys.

This is an interesting thread except for one thing. Why should anyone be adding such a complicated index to a table. If the fellow uses a view for his reports/data entry he could order the results as he suggests. That way he wouldn't be causing a global system performance hit just to support this particular need.

Mike