Skip to Content
Former Member
Nov 07, 2013 at 01:05 PM

Logic to compare two fields without same structure


Hi Gurus, I have to compare in one table reading another table, two table fields which come from SAP and another system. This is the criteria: Example of data stored on FIELD 1 : ( field Last Name on SAP ) Mariana-Paula Ferray Souza Example of data stored on FIELD 2 : ( string that comes from another system ) Mariana Ferray I need a code that will identify that although field 2 is not equal to field 1 it contains parts of the data from field 1. Thank you, F