Re: Soundex not returning exact matches.

From: Glenn Baron <gbaron_at_dial.pipex.com>
Date: 9 Aug 1999 20:08:37 GMT
Message-ID: <01bee2a2$e87f78c0$e787bc3e@default>

Wow! I've never seen soundex used before in 14 years of being an Oracle pro..

best o' luck

Glenn Baron

Richard Murphy <rmurphy_at_lbpc.com> wrote in article <37AF2F13.CB87DD8C_at_lbpc.com>...
> Any one know why while doing a SOUNDEX or ConText-Soundex search I do
> not receive exact matches of the search criteria. An example is:
> SELECT name FROM name_table
> WHERE SOUNDEX(NAME) = SOUNDEX('McGowan');
>
> On some names i will not get any rows that have a 'McGowan' in it
> (plenty of other names), on others like 'Murphy' i'll only get a partial
> listing.
>
> Perhaps Oracle does not like Irish names.
>
> sample table data:
> McGowan; Sharon B
> McGowan; Mark W
> McGowan; Patricia
> McGowan; Gregory L
> McGowan; Mary K
> McGowan; Thomas A
> McGowan-Heredia; Kristen
> McGowan; Christine J
> McGowan; Michael R
> McGowan; Julie A
>
> Thanks, R.M.
>
>
Received on Mon Aug 09 1999 - 15:08:37 CDT