SOUNDEX in SQL-Select with like?
From: Michael Buresch <IT_JMHE_at_CSI.COM>
Date: Mon, 07 Feb 2000 11:11:53 +0100
Message-ID: <389E9A69.C537DB5C_at_CSI.COM>
Hallo,
Date: Mon, 07 Feb 2000 11:11:53 +0100
Message-ID: <389E9A69.C537DB5C_at_CSI.COM>
Hallo,
1.)
when I say:
SELECT EMPL_NO,NAME FROM EMPL WHERE NAME = 'MEIER'
[Quoted] [Quoted] 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 - 11:11:53 CET