1 Reply Latest reply on Jun 12, 2014 9:07 AM by Mike-Matthews-Oracle

    Fuzzy query on External database lookup




      We have a requirement to peform the Fuzzy Query on external database. Lets say we have the below table where it has all CITY, STATE, ZIP combinations in the table. Before sending the address to Loqate address verification, we wanted to check if the given city state postal code combination exists in the external table or not.


      CItyStatePostal Code
      ST LOUISMO63101


      If the user keys SAINT LOUIS, it should check this table with the %LOUIS% and then return the result. similarly for ST-LOUIS it should fire the query ST%LOUIS. Basically it should find the matches in bits and pieces.


      Please let us know if the Fuzzy lookup is possible against the external database.