Why does PL/SQL not support 0 length strings?
Why does Trim(' ') return null instead of an empty string?
Why does '' return null instead of an empty string?
Because of this, LENGTH(Trim(' ')) returns null. And I want zero.
I ask because I'm cutting up a string and in other languages (even ones that support Null) when these techniques are used, I get a valid empty string.
Am I wrong in feeling that an empty string is the equivilent to a 0 in a numeric field and that null in a string is equivilent to null in a numeric field?
Andy