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
