Null vs Empty

  • Thread starter Thread starter §Chrissi§
  • Start date Start date
§

§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
 
No. NULL is null; "" is empty string.

If you want to test for both conditions:
Is Null Or = ""
 
Yes, as long as the "Allow Zero Length String" property of the field is set
to Yes.
 
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>
 
Back
Top