>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.
See chrtran() and strtran(). You could also use a lookup table.
If you explain why you to do this, we might give more specific suggestions.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)