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

    Fuzzy query on External database lookup

    1530264

      Hi,

       

      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
      MOUNT ST HELENSWA98611

       

      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.

       

      Thanks