What is a percentage good for??? IMO, it says almost nothing. But I do agree that like() is only a certain type of comparison.
E.g. "whats?p?" will match with "whatsapp" but not with "what's up"
>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.
Groet,
Peter de Valença
Constructive frustration is the breeding ground of genius.
If there’s no willingness to moderate for the sake of good debate, then I have no willingness to debate at all.
Let's develop superb standards that will end the holy wars.
"There are three types of people: Alphas and Betas", said the beta decisively.
If you find this message rude or offensive or stupid, please take a step away from the keyboard and try to think calmly about an eventual a possible alternative explanation of my message.