Mario Weilguni writes:> This gets really bad when the actual data is coming from a> webinterface, I've to handle 2
differentqueries for the case empty> string and non-empty string.
In their documentation both Oracle 7 and 8 state:
Oracle currently treats a character value with a length of zero as null. However, this may not continue to be
truein future releases, and Oracle recommends that you do not treat empty strings the same as NULLs.
--
Pete Forman -./\.- Disclaimer: This post is originated
Western Geophysical -./\.- by myself and does not represent
pete.forman@westgeo.com -./\.- the opinion of Baker Hughes or
http://www.crosswinds.net/~petef -./\.- its divisions.