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