HI Have two different fields coming from two different sources.
When i do comparision i would like to mark it as perfect when 90% of the data matches how can we do this kind of comparision.
Ex: data 1: 1044 lakehurst drive,Apt #103, waukegan ,il
Data 2: 1044 lakehurst dr Apt 103 waukegan ,il.
O/p Data1=data2.
Regards,
Naveen.