>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
How about index expresion iif(!empty(start_dt),'1','0')+dtos(start_dt))
MVP-2006-2011, PHD in Math and Physics ,
host of
www.foxclub.ru,
VFP lector at Interface and Microinform companies
Head science researcher of VNIIA Rosatom.