>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

Brenda,
They're not the same SQL (first one depends on 'set ansi').
Cetin