Received: from cloud.ndh.net (cloud.ndh.net [195.94.94.16]) by hub.org (8.9.3/8.9.3) with ESMTP id NAA54504 for ; Sat, 8 May 1999 13:00:52 -0400 (EDT) (envelope-from henrik@steffen.stade.net) Received: from ppp05235.01019freenet.de ([212.81.148.115] helo=steffen.stade.net) by cloud.ndh.net with esmtp (Exim 2.05 #1) id 10g9cv-0000Wi-00 for pgsql-sql@postgresql.org; Sat, 8 May 1999 18:06:57 +0200 Message-ID: <37346D43.419B4AFA@steffen.stade.net> Date: Sat, 08 May 1999 18:58:43 +0200 From: Henrik Steffen Organization: city-map X-Mailer: Mozilla 4.5 [en] (Win98; I) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: TRANSLATE() Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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