Re: SOUNDEX in SQL-Select with like?

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 - 04:39:39 CST