by 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?
Thanks
-Jim Martin