Null vs Empty

[§Chrissi§]

Hi All,

Is Null and empty string the same in Access2003? I used IS NULL and ='' in
the WHERE clause. The result is the same. Thanks.

Chris

 

[Ken Snell \(MVP\)]

No. NULL is null; "" is empty string.

If you want to test for both conditions:
Is Null Or = ""

 

[§Chrissi§]

Thanks. Is there a way to store an empty string in a text field directly?

Chris

 

[George Nicholson]

Yes, as long as the "Allow Zero Length String" property of the field is set
to Yes.

 

[Ken Snell \(MVP\)]

Assuming that the field allows empty strings, you can type
""
directly into a control bound to that field, or directly into the field when
the table is in datasheet view.

Or you can run an update query that will write "" into a field.
--

Ken Snell
<MS ACCESS MVP>