Posted by bbla32 on 02/19/07 23:53

> when DM.ReceiverDepartmentID is null, it returns 1 instead of 0?


I changed to

WHEN DM.ReceiverDepartmentID IS NULL OR DM.ReceiverDepartmentID NOT
IN ...

and

WHEN DM.StationID IS NOT NULL AND DM.StationID IN ...

I suppose it should be ok now.

[Back to original message]