>>>>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
>>
>>Excellent! Thanks Edward.
>
>You know, this one is probbaly even better:
>index on iif(field1=0,field1,1/field1) tag q desc

I should be patient, you keep getting better solutions :)