Mike,

Thanks for reply. I dont want full index key as Asce/Desc, I want index fields to be sort ascending/descending. Means index on two fields Asce and two on Desc.

Thanks
Amit

>>I am using Index for sorting the grid. But now i want to sort fieldwise with Ascending Descing options. Index on doesnot support fieldwise Ascending/Descending options. So is there any other way to sort the grid?
>
>Specify Asc or Desc when setting the order, look at all the SET ORDER clausees.