On Thu, 1 Jul 2004, Roberto [iso-8859-1] João 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,
On Thu, Jul 01, 2004 at 16:42:29 -0300,
Roberto João Lopes Garcia <[EMAIL PROTECTED]> 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:
This isn't a bug. If either operand of || is NULL, then the