Torgny,
Try:

INDEX ON cAuktCID + cObjectCID + STR(nOffer) + PADL(100000-VAL(cid),6,"0") DESCENDING TAG test

HTH

>Can anyone help me with the right syntax for an indexkey that sort the following data:
>
>
>cAuktCID cObjectCID nOffer CID
>" 21" " 83" 567.00 " 129"
>" 21" " 83" 567.00 " 126"
>" 21" " 83" 567.00 " 128"
>" 21" " 83" 650.00 " 125"
>
>
>I want it to look like this when it's indexed.
>
> Desc Desc Desc Asce
>" 21" " 83" 650.00 " 125"
>" 21" " 83" 567.00 " 126"
>" 21" " 83" 567.00 " 128"
>" 21" " 83" 567.00 " 129"
>
>I have tried with this, but i does not work:
>cAuktCID + cObjectCID + STR(nOffer) + STR(VAL(cid)*-1) DESCENDING
>
>The 3 first columns gets sorted right but CID-column always
>ends up in descending order although i use -1 in the calculation.
>What am i missing here ?