UFN_ADDRESS_NEEDSATTENTION

                create function dbo.UFN_ADDRESS_NEEDSATTENTION(@ID uniqueidentifier) returns bit with execute as caller
                    as
                    begin
                        declare @RETVAL bit = 0;

                        select @RETVAL =
                          case when DONOTMAIL = 1 or ISCONFIDENTIAL = 1 then 1
                          else 0 end
                        from dbo.ADDRESS where ID = @ID

                        return @RETVAL
                    end