>I can't use '=' instead of '==' as i need an exact match on the street_ref i.e. I may have a street_ref of A123 and another of A123AB?
>
>As for the recno() I'll need to change that.
Hi,

You can also SET ANSI to change VFP's behaviour on SQL string comparisions.


hth
-Stefan