Re: similarity of names

From: <fransh_at_hotmail.com>
Date: Mon, 9 Mar 2009 07:52:48 -0700 (PDT)
Message-ID: <f3c5c682-6905-4d24-8ef0-89f9499b6599_at_r34g2000vba.googlegroups.com>

On 9 mrt, 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(rep­lace(
>         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

UTL_MATCH? hth,
Frans H., Received on Mon Mar 09 2009 - 09:52:48 CDT