I'm sure SET NEAR ON worked correctly in VFP6. Perhaps, where is a bug in version VFP8? Do we have the same behavior in VFP9?
Well, it would help, if I can read documentation. It clearly states, it applies to FIND and SEEK and doesn't mention LOCATE.
>Hi everybody,
>
>I have these values in my cursor
>
>CodeVal
>0100
>0101
>0110X
>etc.
>
>I do
>SET NEAR ON
>LOCATE FOR upper(CodeVal) = "0102"
>?recno()
>
>It returns 581 (I have 580 records in this cursor). Why it's not working and not giving me the third record? I have SET EXACT OFF as well.
If it's not broken, fix it until it is.
My Blog 
