UFN_FINANCIALINSTITUTION_ISUNIQUE_2

        create function dbo.UFN_FINANCIALINSTITUTION_ISUNIQUE_2
        (
            @FINANCIALINSTITUTION nvarchar(100),
            @BRANCHNAME nvarchar(100),
            @ROUTINGNUMBER nvarchar(9),
            @SORTCODE nvarchar(8),
            @BSB nvarchar(7),
            @INSTITUTIONID nvarchar(8),
            @BANKNUMBER nvarchar(7),
            @BIC nvarchar(11),
            @BANKCODE nvarchar(25)
        )
        returns bit
        with execute as caller
        as begin
            declare @DUPLICATECOUNT int;

            select
                @DUPLICATECOUNT = count(ID)
            from
                dbo.FINANCIALINSTITUTION
            where
                ISSPONSORINGINSTITUTION = 0 and
                FINANCIALINSTITUTION = @FINANCIALINSTITUTION and
                BRANCHNAME = @BRANCHNAME and
                (
                    (@ROUTINGNUMBER <> '' and ROUTINGNUMBER = @ROUTINGNUMBER) or
                    (@SORTCODE <> '' and SORTCODE = @SORTCODE) or
                    (@BSB <> '' and BSB = @BSB) or
                    (@INSTITUTIONID <> '' and INSTITUTIONID = @INSTITUTIONID) or
                    (@BANKNUMBER <> '' and BANKNUMBER = @BANKNUMBER) or
                    (@BIC <> '' and BIC = @BIC) or
                    (@BANKCODE <> '' and BANKCODE = @BANKCODE) or
                    (
                        @ROUTINGNUMBER = ROUTINGNUMBER and
                        @SORTCODE = SORTCODE and
                        @BSB = BSB and
                        @INSTITUTIONID = INSTITUTIONID and
                        @BANKNUMBER = BANKNUMBER and
                        @BIC = BIC and
                        @BANKCODE = BANKCODE
                    )
                )

            if (@DUPLICATECOUNT <= 1)
                return 1;

            return 0;
        end