I have a table of collateral items. The collateral items belong to an loan. The collateral table has the field obligation, seq, desc, start_dt, comp_dt. One obligation can have many collateral records, so the seq field is a numeric field that starts at 1 for each new obligation collateral item.

I want to be sort the table records so that the "to do" items are shown first. Meaning that the records with the earliest start_dt that has an empty(compt_dt) should show first. But .... the obligation records need to stay together in a group by obligation, seq order.

If I could accomplish this in an index that would be ideal.

Any help would be appreciated.

Brenda