I know this is possible, but I can't seem to get the syntax correct. Any help would be much appreciated.


Where bi.EDIID = 5444 AND (
                   (bid.ssn IS NULL and el.PersonId is NOT NULL)
            or
                    (el.personid is NULL and bid.ssn is NOT NULL)
            or
CASE WHEN (bid.SSN IS NOT NULL AND el.personid IS NOT NULL)
    THEN ((el.PremiumDue <> bid.PremiumDue)
       or (el.PremiumDueRound <> bid.PremiumDueRounded))
ELSE (1 = 2)
END


http://www.jtechonline.com"

__________________
&lt;a href=\"http://www.jtechonline.com\"&gt;JTechOnline&lt;/a&gt;