>>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?
>
>index on (numfield+999999999) % 1000000000 tag whatever
>
>Put your favorite number of zeros and nines.

Thanks Dragan, but Edward P. came up with this, which I think is more aesthetic and generalizable:

"index on iif(field1=0,field1,1/field1) tag q desc"