The Oracle 9iR2 docs on SQL functions describe soundex.
Head over to http://docs.oracle.com.
Best regards,
David B. Wagoner
Database Administrator
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 09, 2003 8:49 AM
To: Multiple recipients of list ORACLE-L
Subject: anyone have any soundex scripts?
I was on a project a few years ago where we used a soundex algorithm to determine and eliminte duplicate data.
For example we would have:
301 Fairfield Lane
301 Faerfield Lane
Notice the typo? The soundex algorithm caught it. Unfortunately I forgot to grab a copy before I left. Everytime I do a google search on soundex I get a theory website explaining the math behind it.
anyone have one written? or know where I can find one? It is incredibly useful.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: <[EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
