Re: SOUNDEX in SQL-Select with like?

Who have cerated a function, and can post it?

Best regards,
Michael

Martin Haltmayer wrote:

> You have to prepare a function word_soundex that returns the
> concatenated soundex values of the words that its argument consists of.
>
> Then you can do
>
> select empl_no, name from empl where word_soundex (name) = soundex
> ('meier')
>
> Martin
>
> Michael Buresch wrote:
> >
> > Hallo,
> >
> > 1.)
> > when I say:
> > SELECT EMPL_NO,NAME FROM EMPL WHERE NAME = 'MEIER'
> > i get all records with name = MEIER -> O.K.
> > 2.)
> > when I say:
> > SELECT EMPL_NO,NAME FROM EMPL WHERE SOUNDEX (NAME) = SOUNDEX ('MEIER')
> > i get all records with name = MEIER, MAYR, MEUER, etc. -> O.K.
> > 3.)
> > when I say:
> > SELECT EMPL_NO,NAME FROM EMPL WHERE NAME LIKE '%MEIER%'
> > i get all records with name = MEIER, SCHULK & MEIER, etc. -> O.K.
> > 4.)
> > But how do I crete a SQL Select with SOUNDEX and like???????????????ß
> >
> > Best reagrds,
> > Michael
Received on Mon Feb 07 2000 - 06:22:52 CST