>Trying to find the best method for creating an index on a free table. I want the rows that have a !empty(start_dt) to sort to the top in ascending order followed by rows that do not have a start date.
>
>Thanks
>
>Brenda
INDEX ON Start_Dt DESCENDING TAG MyTag
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer