Re: Weird Query

Hi,

> There is no way to tell an oracle database that there is a known
> zero-value string?

Obviously not.

 > This information depraves to NULL?

I am happy to note that I am not the only person who thinks this behaviour is inconsistent bordering on wrong. It is inconsistent with the behaviour of numeric values. I also feel a NULL value is different from an empty string so information is being in fact lost when a database internally converts '' to NULLs.

If one takes the position that indeed an empty string does not exist then I would have preferred an error to be returned either at the INSERT/UPDATE specifying '' or for the "WHERE Field=''".

OK, I did not read any manual, I admit to that. In defense I quote that I am not seriously developing for Oracle. As already said my application does not expect much from the database it runs on - it *does* use Paradox. Still the Oracle-Backend has the most special cases...

Ciao, MM

-- 
Marian Aldenhövel, Rosenhain 23, 53123 Bonn. +49 228 624013.
http://www.marian-aldenhoevel.de
"It's easy to make a small fortune in aviation,
  provided you start with a big one"