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, then the result of the
<concatenation> is the null value."

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to