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.