Re: '' IS NULL?

>>Because a space is considered a character. So if you create a space in a
>>field, it is no longer considered NULL.
 

>Then there is no such thing as a zero-length string? In other words, a
>"known" value of nothing, rather than an "unknown" value.

The options are:

' '				a space
''				a zero-length string
(nothing)		NULL