>I have a field containing records like the following:
>
>AA,AA,AA,BB,BB,DD,EE,EE,EE,EE,EE,FF,FF,FF
>
>
>If I order them they come out as above.
>
>I need say the FF to come before the EE, and the rest to stay the same.
>
>Anyone any ideas how this could be done.

index on iif(myField='FF' or myField<'EE','0','1')+ myField tag myOwnSort