Soundex not returning exact matches.

From: Richard Murphy <rmurphy_at_lbpc.com>
Date: Mon, 09 Aug 1999 14:42:11 -0500
Message-ID: <37AF2F13.CB87DD8C@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 - 14:42:11 CDT