select soundex(string1), soundex(string2)

select soundex(string1), soundex(string2)

Post by hugh » Tue, 14 Jan 2003 23:23:49



hi,

i use those functions from sqlserver2000:
"select soundex(string1), soudex(string2)" and "select difference(string1,
string2)"

i need to reduce connections to my database in my VB.net application.
does anyone know if MS provides those functions anywhere else, like a dll?
or even if there is any other way to compair strings, returning a score for
similarity?

thanks,
hugh

 
 
 

select soundex(string1), soundex(string2)

Post by BP Margoli » Wed, 15 Jan 2003 03:59:33


Hugh,

Please do not post the same question independently to multiple newsgroups.

Please see my reply in .msde

-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.


Quote:> hi,

> i use those functions from sqlserver2000:
> "select soundex(string1), soudex(string2)" and "select difference(string1,
> string2)"

> i need to reduce connections to my database in my VB.net application.
> does anyone know if MS provides those functions anywhere else, like a dll?
> or even if there is any other way to compair strings, returning a score
for
> similarity?

> thanks,
> hugh


 
 
 

1. pgsql/contrib/soundex (soundex.c soundex.sql.in)


Author: tgl

Update of /home/projects/pgsql/cvsroot/pgsql/contrib/soundex
     from hub.org:/home/projects/pgsql/tmp/cvs-serv51753/contrib/soundex

Modified Files:
        soundex.c soundex.sql.in

-----------------------------  Log Message  -----------------------------

Revise handling of oldstyle/newstyle functions per recent discussions
in pghackers list.  Support for oldstyle internal functions is gone
(no longer needed, since conversion is complete) and pg_language entry
'internal' now implies newstyle call convention.  pg_language entry
'newC' is gone; both old and newstyle dynamically loaded C functions
are now called language 'C'.  A newstyle function must be identified
by an associated info routine.  See src/backend/utils/fmgr/README.

2. Assigning an variable to UNSIGNED INT

3. pgsql/contrib/soundex (soundex.c)

4. Paradox 4.5 -> SQL Link -> ORACLE question

5. SOUNDEX in SQL-Select with like?

6. Can't modify and save a table thru mysql odbc

7. SOUNDEX Performance

8. Ref cursor and Active Server Page - does it work?

9. Soundex and "look-alike" searches

10. SOUNDEX

11. MS SQL Soundex function

12. soundex - usage