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.

Frank van Bortel