Re: '' IS NULL?

On Mon, 11 Dec 2000 02:32:59 GMT, Bert Byfield <rpitts_at_rochester.rr.com> wrote:

>>>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
>

->SELECT * FROM Dual WHERE '' IS NULL;

D
-
X

It would seem that they are the same thing.

Brian. Received on Sun Dec 10 2000 - 21:46:58 CST