Alternative to SOUNDEX to get nearby geographical locations. RRS feed

  • Question

  • CASE WHEN SOUNDEX(websiteVisitCity) = SOUNDEX(BilligCity) THEN 1 ELSE 0 END match

    I'm trying to isolate travelers from receiving promotion emails from same or nearby cities. to do that I'm using their last visit city location  which is a free form field in website  and provided billing city. This fails in cases like websiteVisitCity = Concord and Billing city = Charlotte,NC. 

    is there a way in SQL to identify surrounding geographical locations and ignore them . 

    I do not think so but any help is appreciated. 




    Tuesday, May 8, 2018 3:58 PM

All replies