Hello all. I have a SQL Server 2000 db that has a table with ~10 million rows with a column LastName. Is there a way to perform a search on that column for a last name that "sounds like" my search criteria?
For example, if I search for the last name 'Meyers', I would like for it to return Meyers, Myers, Miers, etc. I'm trying the "soundex" function, but it returns too many rows. It's algorithm is not very restrictive, I don't believe.
Has anyone had to tackle this problem? I'm not married to the "soundex" function idea, so I am open to any suggestions.
Thanks in advance!
APF
For example, if I search for the last name 'Meyers', I would like for it to return Meyers, Myers, Miers, etc. I'm trying the "soundex" function, but it returns too many rows. It's algorithm is not very restrictive, I don't believe.
Has anyone had to tackle this problem? I'm not married to the "soundex" function idea, so I am open to any suggestions.
Thanks in advance!
APF