In the norwegian language we have the extra letters æ,ø and å which are sorted at the end (after z). But - 'aa' can also be used to represent å.
My problem is that I have a list of values that happens to have to adjacent instances of a - and I want them to be sorted as such and not as å (aa)
So, I want to sort the values like this
AATEST
NEW
TEST
What actually happens is
NEW
TEST
AATEST
Any suggestions?