Doubble qoutes, null or space are all diffrent.
Double qoutes means the field have data with binary zero. (asci x'00')
Space means field have data as space not binary zero but code X'20' in asci.
Nulls is not represented in data field. Its indicated that field isnt
initiated.

"KARL DEWEY" skrev:

What can I enter in the criteria that will recognize all of the blank fields?
There are more than one thing that can appear as a blank. There are nulls
and zero lenght strings.
Use this to pull both --
Is Null OR ""
That is two double quotes.

--
Build a little, test a little.


"Jodie" wrote:

I need to do an update to change all blank fields to a 0 (zero). In the
criteria, I have tried IsNull and it is not returning any of the blank
records. I have tried IsEmpty and I get a message that say mismatch. What
can I enter in the criteria that will recognize all of the blank fields?
--
Thank you, Jodie