General information
Category:
Coding, syntax & commands
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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only