>I have a numeric field I'm trying to index. The data in the field look like, for example:
>
>0,2,5,0,12,0,0,15,17,...
>
>I want to order them like:
>
>2,5,12,15,17,0,0,0,0,...
>
>Any ideas how I can do this?
calculate max(field1) to nMax
index on iif(field1=0,nMax+1,field1) tag q
set order to q
Edward Pikman
Independent Consultant