>I saw this kind of search in some softwares
> It's useful when one doest not know how to spell
> the name word
>
>I don't know if its possible in VFP
>
> locate "SOAN"
>
> Will return
>
> SONA
> ONAN
> NASO
>

In addition to the other responses, you might want to take a look at the Nov. 2002 issue of FoxPro Advisor. It has some sample code for "fuzzy" searching. It's based on an algorithm by John Ratcliff and David Metzener:

http://www.ddj.com/documents/s=1103/ddj8807c/8807c.htm