>>>Any way to do fuzzy searching in VFP.
>>>
>>>Preferably in french ;-)
>>>
>>>If you can provide some code then I guess I can adapt for french.
>>
>>What exactly are you trying to do? For indexed searches there is GOTO RECNO( 0 ) / SET NEAR. For character strings there is SOUNDEX() / DIFFERENCE().
>
>I'm trying to do the following;
>
>If user enters he's looking for "Rene" I want to find "Rene" and "René" for example.

You could potentially use DIFFERENCE() or SOUNDEX().

?DIFFERENCE( "Rene", "René" ) &&4
?DIFFERENCE( "Rene", "Rend" ) &&3
?DIFFERENCE( "Rene", "Remd" ) &&3
?DIFFERENCE( "Rene", "Rané" ) &&4
?DIFFERENCE( "Rene", "Sané" ) &&3
?DIFFERENCE( "Rene", "Sené" ) &&3
?DIFFERENCE( "Rene", "Bané" ) &&3
?DIFFERENCE( "Rene", "Bamé" ) &&3

* so, you could experiment with
IF DIFFERENCE( SomeColumn, "Rene" ) = 4

* SOUNDEX() is more difficult to interpret:
?SOUNDEX( "Rene" ) &&R500
?SOUNDEX( "René" ) &&R500
?SOUNDEX( "Remd" ) &&R530
?SOUNDEX( "Remé" ) &&R500
?SOUNDEX( "Relé" ) &&R400
?SOUNDEX( "Redé" ) &&R300
?SOUNDEX( "Resé" ) &&R200
?SOUNDEX( "Sene" ) &&S500
?SOUNDEX( "Réjean" ) &&R250

* maybe if you force the first letters of the SOUNDEX() results to be the same,
* and the remaining numbers to be "close" e.g.
lcSoundexChar1 = LEFT( SOUNDEX( SomeColumn ), 1 )
lcSoundexChar2 = LEFT( SOUNDEX( "Rene" ), 1 )
lnSoundexVal1 = VAL( RIGHT( SOUNDEX( SomeColumn ), 3 ) )
lnSoundexVal2 = VAL( RIGHT( SOUNDEX( "Rene" ), 3 ) )

IF lcSoundexChar1 ==  lcSoundexChar2 ;
  AND ABS( lnSoundexVal1 - lnSoundexVal2 ) < ( some numeric value )

* you might be able to combine them,
* do a quick check with DIFFERENCE(),
* then fine-tune with SOUNDEX()