>>If you want this behaviour you will have to explicitly handle it withCOALESCE().>>regards,>Lukas
True. But there's a point where oracle is really better here, they named"coalesce" "nvl" => a lot easier to type ;-)