>>My disclaimer ... it was late last night ..... and I could not get an SQL statement to work that had always worked previously.
>>
>>subnum is a 5 character field and parcel is a 12 character field. So subnum is matching on the first 5 characters of parcel.
>>
>>SELECT pao1.* FROM pao1, sub INTO CURSOR sub2 WHERE ALLTRIM(subnum) = PARCEL
>>
>>When the SQL kept returning an empty cursor I rewrote the SQL to the following and it worked.
>>
>>SELECT pao1.* FROM pao1, sub INTO CURSOR sub2 WHERE parcel like ALLTRIM(subnum)+ '%'
>>
>>Now in the morning, the original SQL is working. Is the only explaination was that it was late at night?
>>
>>Brenda
>
>Different values for SET ANSI ?

Good thought, although I have never SET ANSI. So I suppose it is always the default. Is SET ANSI influenced by the SET ENGINEBEHAVIOR?

Is it me or are there just a ton of errors in the VFP9 Help? When reading the SET ANSI, the two examples both use the SET ANSI ON and show different results.