Today, in preparation for bringing my live Q&A data into my Sesame databases, I tried some experiments.  I flushed all my test data out of the Customer database, exported my Q&A data to a standard comma-delimited text file, and imported it into Sesame.  I got no error messages, so it seems as if everything went fine.

Then I tried a retrieve, using /0 as my spec, in the "Discount" field (this is a number field).  Of 10075 customer records, only 9 have a value in that field; all the rest are blank.

But the retrieve returned all 10075 records.  I changed the spec to >0 and the 9 I wanted were returned.

I thought that was strange, that /0 would return records where the field was empty.  So I thought that maybe an invisible "space" was in there.  So I started over, and this time I did not export, nor did I import, the Discount field.  Yet again, /0 returned all records.

So I tested another database, my personnel database.  Some of the records have an amount in the Uniform field but most do not (this is a money field).  Again, /0 returned all records.

Not sure what's going on, but it's probably me misunderstanding something rather than an error with the program.

Thanks Mark, I understand that.  However, what I'm looking for are records where the specific element is not Zero.  I'm surprised that blanks meet that qualification.  My assumption is that, in a numerical or money field, a blank would be considered zero.  In Q&A, with the same database, a retrieve spec of /0 returns only the 9 records with an amount in them.  In Sesame, all records are returned, including all the blanks.  Like I said, I'm probably misunderstanding something.