Re: SOUNDEX in SQL-Select with like?

From: JOC <oconnorj_at_freenet.co.uk>
Date: Mon, 07 Feb 2000 14:33:00 GMT
Message-ID: <389ed75e.227320481_at_NEWS>


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

On Mon, 07 Feb 2000 11:11:53 +0100, Michael Buresch <IT_JMHE_at_CSI.COM> 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
>


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


Received on Mon Feb 07 2000 - 15:33:00 CET

Original text of this message