Re: AW: ORDER BY problem

On Tue, 8 Jun 2004, Franz, Fa. PostDirekt MA wrote: Hi, it is not possible to handle all cases proper. You can just handle all cases you know with the REPLACE-function, so you simply delete the prefixes in the WHERE-clause. But that only works for all prefixes you know. If you do like

AW: ORDER BY problem

Hi, it is not possible to handle all cases proper. You can just handle all cases you know with the REPLACE-function, so you simply delete the prefixes in the WHERE-clause. But that only works for all prefixes you know. If you do like ORDER BY REPLACE(REPLACE(surname,'du',''),'de','') you get all