Can someone please help explain if the empty '' means something?
I am wondering if it might be inserted by typo or if you use these empty quotes to locate empty fields within the attributes.
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It only takes a minute to sign up.Sign up to join this community
Yes, it'll select all rows where the COMMENTS field is empty. I just tested and it also selected rows with a single space: ' ' (tested with an .mdb feature class).
However, it will not select Null values (use IS NULL for that).