SoundEx ?

SoundEx ?

Post by Stev » Wed, 17 Apr 2002 23:54:13



Does MS SQL 7/2000 have Soundex (utility that calculates
the sound of strings)? I've seen it on Oracle servers, and
wish to implement it within a stor proc.

Thanks.

 
 
 

SoundEx ?

Post by lindawi » Thu, 18 Apr 2002 00:06:46


Steve,

Quote:> Does MS SQL 7/2000 have Soundex (utility that calculates
> the sound of strings)? I've seen it on Oracle servers, and
> wish to implement it within a stor proc.

Yes. Look at the SOUNDEX and DIFFERENCE functions in Books Online.

Linda

 
 
 

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. multiple update in column

3. select soundex(string1), soundex(string2)

4. ORDER BY vs. UPDATE

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

6. SQL, embedded SQL as public domain?

7. SOUNDEX Performance

8. MO-DBAS NEEDED

9. Soundex and "look-alike" searches

10. SOUNDEX

11. MS SQL Soundex function

12. soundex - usage