Ken, I've got a good one that I'll post up tomorrow when I get into work. Unfortunately I don't have it to hand at the moment.
Dave Crozier -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kenneth Kixmoeller/fh Sent: 09 October 2006 18:56 To: Profox Subject: So much for SOUNDEX() Hey - - - Working on d-f'ing up the information in a poorly-designed database. Using SOUNDEX() for "close" comparisons. One it missed: Highway Federal Credit Union = H200 F364 C633 U550 Hiway Federal Credit Union = H000 F364 C633 U550 I woulda thunk.... but then again, it ignores vowels... any soundex() replacement out there???? Ken [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

