Re: Oracle 7.1 Enhancements

In article <Cr3p9s.D9_at_freenet.carleton.ca> ah513_at_FreeNet.Carleton.CA (Doug Harris) writes:
>
>
>In a previous article, jdennis_at_netcom.com (John Dennis) says:
>>
> I would also like to know if 7.1 can distinguish between empty
>CHAR/VARCHAR values (i.e. '') and NULL.
>

Please explain. NULL and empty values are conceptually the same thing. What exactly is the question here?

Are you experiencing differences in behaviour between statements such as these two:

      select a||null from b;

and

      select a||'' from b;

I'm confused. ):-(

-- 
============================================================================
Michael Sallwasser  | Down one path is utter dispair and hopelessness. Down 
Northrop Grumman    | the other is total destruction. Let us choose wisely.
============================================================================