Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 parial match in a record field

Author  Topic 

ykuoles
Starting Member

1 Post

Posted - 2011-08-22 : 08:42:34
hello guys,
I have a table with ID, CompanyName and flag fields, having 4000 records. Some of these records have the same company name, but with in different formats, example:
"Europe African Bank" similar to "Bank of Europe Africa"

What I am looking for is a Query or a Stored Procedure to find the records with a possible match and place "1" in the flag field. The process should not be 100% accurate, as the flag field will be used for a later human processing. Any idea what can I do ??

Thx

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-08-22 : 09:18:38
see below. this might give you what you want

https://sites.google.com/site/sqlblindman/fuzzysearchalgorithm

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -