sql server soundex problem

sql server soundex problem

Post by Jim » Wed, 04 Dec 2002 04:35:00

Greetings.  I'm using sql server 2k to hold some names and
addresses which I allow people to search using soundex
values of the names.  that all works great for me, except
I have one glaring problem:  I don't think sql server is
calculating soundex values correctly.  I use a function
that I got from some vb help site that will calculate sx
values which I then pass to sql server.  So consider this
example:  soundex('Scroggins') returns S262 in sql server,
but my function returns S625.  I would assume that my
function is wrong, except that just for fun I tested that
in Oracle, which happily returned S625, agreeing with my
function and disagreeing with sql server.  Has anyone ever
seen this and is there a solution that doens't involve me
hard coding soundex values in the table or writing my own
sql function to do it?

-Jim Martin


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.


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

4. pass the value from my VB form to Data Report's label control

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

6. Stored Procedures vs Embedded SQL

7. Problem connecting one SQL Server server to another SQL Server server

8. What Happened to STOCK

9. Soundex problems....

10. Soundex problem

11. Soundex Problem

12. SOUNDEX problem with non-english letters

13. Problem with SOUNDEX()