Re: string concatenator || and NULL values

On Thu, 1 Jul 2004, Roberto [iso-8859-1] Jo=E3o Lopes Garcia wrote:

> When I use string concatenator || and there are fields of type date whith=
 NULL values
> the result is an enpty string. Please see example:

The result is NULL.  This is the correct result.

"If either S1 or S2 is the null value, then the result of the
<concatenation> is the null value."