January 15, 2007 at 12:34 pm
I have a sql table with customer reslated data ex(cust_name,cust_id,cust_address, cust_phone, cust_zip and so on). Theres a spreadsheet with similar details in .csv format. Is it possible to compare the data in sql with .csv file using some FUZZY logic assuming that the cust_name or any other column can have mismatching data but sounding the same. Ex in my sql table if i have cust_name as 'John' my xls will have same inofrmation as 'Jon' but rest of the information could be exactly the same. I would really appreciate if anyone has worked on a similar situation or have code which could resolve this problem.
Thanks
January 15, 2007 at 12:46 pm
You might want to look into using the SOUNDEX function. I would recommend you actually look into (if you can), Ken Henderson's "A Better SOUNDEX()" from his book The Guru's Guide To Transact-SQL.
Tread carefully though.
January 15, 2007 at 1:04 pm
On the very same lines. The DIFFERENCE() function was written for stuff like that. It's worth a look in your case.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply