>Hi all,
>
>I have a compound index on the following expression, cnoee+DTOS(dtrans)+cdtrans where cnoee is Employee #, dtrans is date and cdtrans is code. Is there any way I can do descending on dates but acending on the others? Presently I can only think of using a large number to minus DTOS(dtrans). Any other way?
>
>Thanks.
Farouk,
Try this. 'index on cnoee+STR({12/31/2099}-dtrans)+cdtrans'. Please let me know if this is successful.
Good Luck,
Bill Chadbourne
wchad@ime.net
William Chadbourne
Senior Programmer/Analyst
State of Maine - DAFS App Team
Oracle - When you care enough to use the very best!!