I have a table x with field Address and table y with fields customer_Address., Customer_Name etc
I want to compare tables x and y on the address fields and grab Customer_name . But the address field in x and Customer_address field in y may few of the strings in slight different manner . I want to do the best of comparison.
Please suggest some good ways to do it.
This is what I have done but seems to be very slow.
SELECT x.StreetAddress,y.FULL_ADDRE,t.CITY,x.city,x.LATITUDE,x.LONGITUDE from
on x.StreetAddress LIKE '%' + y.FULL_ADDRE + '%'
and x.City LIKE '%' + y.City + '%'
where x.StateId =22