Contains and Like won't return a match, because the column doesn't contain anything. You would have to add "OR lname IS NULL" to your example, but you wouldn't want to do that if your form has "lname LIKE 'S%' " You would probably have to test where the like clause is, and add the "OR lname IS NULL" if you're searching on the wildcard, but leave the "is null" off if you are searching for an actual value... I can't think of another way.
Karen > 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 >
