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])