>
>
>>With that said if '' does != NULL then what does? Just NULL? In my book
>>NULL means undefined and IMHO you can't get more undefined than ''!
>>
To me, '' is very defined. You're explicitly telling something to be
set to the empty string. It has a definite value - "empty string".
NULL implies that you have no information whatsoever to determine what
the value is.
That's just me. I was always bothered that Oracle did consider empty
strings to be NULLs. =)
-Fran