Gary,
I may be misunderstanding your intention, however the where clause : WHERE lname LIKE '%' Is bascially the same as : WHERE lname IS NOT NULL If you want to return all rows in the table regardless of the LNAME column, simply EDIT USING FORM1 (With no where clause) However, if your example was a more simple example of your actual code, then this may not work. You would need to be more specific on why and how your are using the LIKE '%'. -Bob ----- Original Message ----- From: "Gary Randall" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Monday, May 17, 2010 1:26:48 PM GMT -06:00 US/Canada Central 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
