Hi peter ..thanks for reply
I need something more detailed...where a % rating is returned
Regards,
Gerard


>>Apparently, there is a 'Fuzzy Search' option that can be installed for Excel 2012 (I have Excel 2007)
>> which compares 2 columns and gives a % Match result (e.g. 100%=Exact Match 90%= Near exact etc)
>>
>>Anybody know if:
>>1. This can be done programatically (To exactly replicate what Excle does
>>2. Can it be done in Foxpro or DotNet
>
>See the LIKE() function.