TRANSLATE()

Hello all,

I wonder how I can translate some German special characters for an ORDER
BY clause.

say, you got some German words like these:

Abend
Ära
Opa
Österreich
Übergabe
Ufer

and want to order them in the way above, you will need to translate 'Ä'
into 'Ae', 'Ö' into 'Oe' and 'Ü' into 'Ue' to order them correctly.

I thought of something like this:
SELECT myword FROM words ORDER BY TRANSLATE(myword,'Ä','Ae');

But now I only got one of the cases. How can I combine all the three
translations?

Any help appreciated!


Greetings

Henrik Steffen
http://www.AH-Tuning.de