SQLTeam.com | Weblogs | Forums

Fuzzy matching

Hello

I want to use Soundex to match an external list with the values of a column of a SQL table.

Is there an easy way to do that? Unfortunately SOUNDEX([Col1]) does not seem to work which is very frustrating.

Thanks!

You have asked similar question a few times. Search fuzzy and @sqlor

Are the answers provided for this not satisfactory?

Look back and answer those first

Thanks, this is a bit different, it's actually on how to find the soundex of a whole column.

What does does not seem to work mean?

Please provide the necessary data of table and external list then

1 Like

Basically I need to get the soundex of the below values:

Column1
John
George
Betty
Sue

And select soundex([Column1]) from Table1 does not seem to work?
I would expect to return:

C400
F450
B409
B944
(or whatever the soundex code for each is)

You keep saying "Does not seem to work" i

What does that mean? Is it erroring? Is it producing what you did not expect?

1 Like