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 lik
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
