If you have questions or if you want to share your opinion about Aware IM post your message on this forum
#53523 by ALW
Thu Mar 19, 2020 10:09 pm
I need to do a duplicate check in my system to find Company Names that are similar but may have been entered in a different way - similar to a soundex type of comparison. So for example - if the user is entering in "Walmart" as a new company but the company already exists in the system as "Wal-mart" or they enter in ABC Company but it is already in the system as "A.B.C Company" - I want to alert the user that there is likely a duplicate in the system. Is there a way to do this? I guess I could store the name as another field with no punctuation or spaces and check against this but wanted to see if anyone has run into a similar business need scenario.

Thanks!
#53550 by johntalbott
Sun Mar 22, 2020 2:35 am
SQL Server and MySQL have Soundex functions. You could call a stored procedure that uses a soundex function as part of your duplicate check process.

Who is online

Users browsing this forum: No registered users and 46 guests