The SOUNDEX function returns a 4-character Phonetic code. It is
primarily used to compensate for spelling differences in last names:
Smith
Schmidt
Smythe
all generate the same code, S630, as I recall.
It will not resolve differences in the first character:
Ffiefer
Pfiefer
This is a very old technology (predates computers) that was developed
for the government. I temember an old IBM SOUNDEX manual that was a
reprint of a government manual. It was available in the '60s for
development oh Police Information systems and the like.
I did a sherlock search and found:
http://www.cimorelli.com/pie/faq/pfaq_a15.htm
HYH
Dick
At 9:48 AM -0400 8/22/00, Jeremy Allen wrote:
>There is something called SOUNDEX searches in SQL also which
>in theory return phonetical spellings of words.
>
>Jeremy Allen
>[EMAIL PROTECTED]
>[Insert cool title here]
>
>-----Original Message-----
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>Sent: Monday, August 21, 2000 5:39 PM
>To: [EMAIL PROTECTED]
>Subject: Re: Fuzzy Logic Searches in SQL
>
>
>CONTAINS Predicate is exactly what you are looking for.
>
>However, I do not believe it is part of SQL 6.5. In MS-SQL 7.0 a new feature
>full-text searching/indexing was added. In which I think CONTAIN relies on?
>
>Any hope of upgrading to 7.0? Or possibly using Verity search capability?
>
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.