Solved

Matching Lead Records

Posted on 2007-11-26
2
224 Views
Last Modified: 2010-04-21
This goes back to the age old question, how to match lead records given that users often input names and addresses incorrectly and often times there is no universal ID across divergent systems.

In the way past, i used phone number.  Phone number is awful cause phone numbers can change.  Then i started to use a match code.  I would substring n characters off of name, address, city, zip, etc and see if i could match.  That works fairly well.

Now i'm thinking about going to a soundex match.  

Anyone got THE best way to match lead records across systems?
0
Comment
Question by:davidcahan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 18

Accepted Solution

by:
Yveau earned 500 total points
ID: 20349852
... create a single database for lead data and connect to that database from any other database that needs that kind of data ... only store the 'central ID' in all databases.
Not much help right now, but that is the way to do it ...

soundex can help ... however if there are errors in the first character, soundex won't be any help (see code snippet). as the soundex function is mainly based on the first character ...

Hope this helps ...


select soundex('Weststreet 10'), soundex('reststreet 10')
 
-->> Result:
----- -----
W232  R232

Open in new window

0
 

Author Closing Comment

by:davidcahan
ID: 31410963
good advice on soundex
0

Featured Post

Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
configure service broker on all databases 2 98
Query to return total 6 26
Need help how to find where my error is in UFD 6 52
What is GIS method of Geometry data type? 6 26
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question