RE: soundex

["John Taylor" <john.taylor@xxxxxxxxxxxxxxx>]

Phil,


Here is a PDF file that contains a good article about the soundex algorithm:

http://www.naspa.com/PDF/2000/0300%20TS%20PDFs/T0003010.pdf


HTH,

John Taylor
Canada


> -----Original Message-----
> From: owner-midrange-l@midrange.com
> [mailto:owner-midrange-l@midrange.com]On Behalf Of Phil Groschwitz
> Sent: Tuesday, March 06, 2001 6:04 PM
> To: MIDRANGE-L@midrange.com
> Subject: soundex
>
>
> All,
>
> Does anyone know how soundex decides which records to
> select?
>
> SELECT * FROM customer WHERE soundex(customername) =
> soundex('steal')
>
> returned names with Steele and Steel but also names
> that don't sound anything like steal.
>
> Thanks,
>
> Phil
>
> __________________________________________________
> Do You Yahoo!?
> Get email at your own domain with Yahoo! Mail.
> http://personal.mail.yahoo.com/
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
> david@midrange.com
> +---

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---