SOUNDEX in SQL-Select with like?

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:11:53 CST