• The dreaded IS NULL OR construct is the root issue here. Fix it per Sean's link. Those simply MUST NOT BE ALLOWED ON YOUR SYSTEM - EVER! 🙂

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service