FW: RE: anyone have any soundex scripts?

2003-06-09 Thread Jacques Kilchoer
I guess a link would help. http://www.merriampark.com/ld.htm > -Original Message- > From: Jacques Kilchoer > > Try the Levenshtein Distance algorithm. If you scroll to the > bottom of the page you will see a PL/SQL implementation. > > > -Original Message- > > From: [EMAIL PROTE

Re: anyone have any soundex scripts?

2003-06-09 Thread JApplewhite
You might consider an interMedia Text index on the column(s) of interest. The interMedia Fuzzy Search and scoring functionality (and others) may prove more flexible than Soundex. Jack C. Applewhite Database Administrator Austin Independent School District Austin, Texas 512.414.9715 (wk) 512.935.5

RE: RE: anyone have any soundex scripts?

2003-06-09 Thread Jacques Kilchoer
Try the Levenshtein Distance algorithm. If you scroll to the bottom of the page you will see a PL/SQL implementation. > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > yes, Im familiar with that function. but you have to write a > soundex algorithm in order to

RE: RE: anyone have any soundex scripts?

2003-06-09 Thread DENNIS WILLIAMS
into the SOUNDEX function to make it tell the difference between 301 Fof Lane 301 Faf Lane > > From: "Seefelt, Beth" <[EMAIL PROTECTED]> > Date: 2003/06/09 Mon AM 11:04:53 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE

RE: RE: anyone have any soundex scripts?

2003-06-09 Thread Regis Biassala
; To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: RE: anyone have any soundex scripts? > > > What advanced functionality are you looking for? > > -Original Message- > Sent: Monday, June 09, 2003 10:29 AM > To: Multiple recipients of

RE: RE: anyone have any soundex scripts?

2003-06-09 Thread rgaffuri
Mon AM 11:04:53 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: RE: anyone have any soundex scripts? > > > What advanced functionality are you looking for? > > -Original Message- > Sent: Monday, June 09, 2003 10:29 AM >

RE: RE: anyone have any soundex scripts?

2003-06-09 Thread Tierstein, Leslie
e is one on the web some where. > > From: "Seefelt, Beth" <[EMAIL PROTECTED]> > Date: 2003/06/09 Mon AM 09:59:43 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: anyone have any soundex scripts? > > > There is a SOUNDEX sq

RE: RE: anyone have any soundex scripts?

2003-06-09 Thread Seefelt, Beth
where to start with something like that. Im hoping there is one on the web some where. > > From: "Seefelt, Beth" <[EMAIL PROTECTED]> > Date: 2003/06/09 Mon AM 09:59:43 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: anyone ha

Re: RE: anyone have any soundex scripts?

2003-06-09 Thread rgaffuri
gt; > Date: 2003/06/09 Mon AM 09:59:43 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: anyone have any soundex scripts? > > > There is a SOUNDEX sql function. Check tahiti.oracle.com for info. > > HTH. > > -Original Message

RE: anyone have any soundex scripts?

2003-06-09 Thread DENNIS WILLIAMS
Have you checked out the Oracle SOUNDEX() function? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, June 09, 2003 7:49 AM To: Multiple recipients of list ORACLE-L I was on a project a few years ago where we used a soundex algori

RE: anyone have any soundex scripts?

2003-06-09 Thread David Wagoner
Title: RE: anyone have any soundex scripts? 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

RE: anyone have any soundex scripts?

2003-06-09 Thread Seefelt, Beth
There is a SOUNDEX sql function. Check tahiti.oracle.com for info. HTH. -Original Message- Sent: Monday, June 09, 2003 8:49 AM To: Multiple recipients of list ORACLE-L I was on a project a few years ago where we used a soundex algorithm to determine and eliminte duplicate data. For e