Very Computer

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

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

Who have cerated a function, and can post it?

Best regards,
Michael

SELECT EMPL_NO,NAME FROM EMPL WHERE NAME LIKE '%MEIER%' AND SOUNDEX
(NAME) = SOUNDEX ('MEIER')  ?

Jo

Quote:>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

*************************************************

The usual - anything I say reflects on me, and not upon my current employer.

*************************************************