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 result is NULL. You probably want to use the coalesce function to change NULLs to empty strings. ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
