Re: Easy SQL problem

On Sun, 11 Aug 2002 15:10:18 +0100, Daniel Morgan <damorgan_at_exesolutions.com> wrote:

>What makes you think that '' is NULL?

http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a85397/sql_elem.htm#4008 http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/server.920/a96540/sql_elements5a.htm#59112

 "Oracle currently treats a character value with a length of zero as null."

 I'm probably just getting the wrong end of the stick from some of the posts in this thread, but as far as I'm aware Oracle still doesn't differentiate '' from NULL, which is why column = '' can never match (as column = '' is actually column = NULL, and that is always 'unknown').

-- 
Andy Hassall (andy@andyh.org) icq(5747695) http://www.andyh.org
http://www.andyhsoftware.co.uk/space | disk usage analysis tool