[snip]On 8/2/05, Billy Verreynne (JW) <VerreyB@xxxxxxxxxxxx> wrote:
[snip]An empty string is not the same as a number that is equal to zero.
I don't know a better way to explain it than that.
Well Mark, I in turn cannot understand why people do not seem to grasp the very fundemental concept of what a null is and what a value is. I do agree that dealing with NULLs in Oracle using state operators is not ideal as its easier to deal with NULLs using math operators (and in most other languages). But I do not agree with the misconception that an empty string is somehow different from a NULL string.