Re: Does NULL == ""?

[Bruce Feist]

Randy Chrismon wrote:

>what I'm asking is whether there's a
>difference between a field with NULL in it and a field with a
>zero-length ("") string in it.
>  
>

Yes, there is.  NULL is the absence of a value; an empty string is a 
valid value.  NULL by definition isn't equal to anything, even to 
itself, while "" = "".

Bruce Feist