Re: similarity of names

From: CarlosAL <miotromailcarlos_at_netscape.net>
Date: Mon, 9 Mar 2009 07:31:02 -0700 (PDT)
Message-ID: <ec5ee6bb-b033-40cf-93d0-fbddbede8c5f_at_v19g2000yqn.googlegroups.com>

On 9 mar, 15:09, Norbert Winkler <norbert.winkl..._at_gmx.de> wrote:
> Hi,
>
> we are using this construct
> replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(
>         replace(replace(replace(
>           lower(ANY_NAME),
>         ' ',''),',',''),'ä','a'),'ü','u'),'ö','o'),'ß','s'),'oe','o'
> ),'ue','u' ),'ae','a'),
>         'y','i'),'ll','l'),'nn','n'),'ss','s')
>
> for comparing a given person-name with our database-person-names
>
> is there a better solution or are the multiple replaces fast enough.
> In my programms I iterate char by char and substitute using fast
> case-constructs for substitution.
> But I don't know how fast a char-by-char-solution in a PL/SQL-function
> would be.
>
> --
> Norbert
> Oracle9i Enterprise Edition Release 9.2.0.8.0 64Bit

TRANSLATE() ? HTH Cheers.

Carlos. Received on Mon Mar 09 2009 - 09:31:02 CDT