From: Frank van Bortel on
bob123 wrote:
> OK thanks all ...
> The problem is that i can't rewrite the code
> it's a third party software ...
> any clue ?
>
>
written in a far and distant country, where the programmers had
no clue about the data model.

Speculating, of course, but I've seen these constructs before.

Bet ya those columns are NOT NULL.
--

Regards,
Frank van Bortel