EDIT USING form1
That will get all the rows. Emmitt Dove Manager, Converting Applications Development Evergreen Packaging, Inc. [email protected] (203) 214-5683 m (203) 643-8022 o (203) 643-8086 f [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of Gary Randall Sent: Monday, May 17, 2010 14:27 To: RBASE-L Mailing List Subject: [RBASE-L] - Where Question Hello All, I am running into a issue that I haven't had before and I am out of ideals, I am hoping someone could help me see what I am sure is right in front of me. Here is a where clause I am using: EDIT USING form1 WHERE lname LIKE '%' If there is a row where the lname column is empty this where clause will skip it. I have tried CONTAIN and it behaves the same. Is there a way to make the where clause return all the rows even the ones that have no data in the lname column? Thanks Gary Randall
