UFN_FINANCIALINSTITUTION_GETNAME

            CREATE function dbo.UFN_FINANCIALINSTITUTION_GETNAME(@ID uniqueidentifier)
            returns nvarchar(202)
            with execute as caller
            as begin
                    declare @INSTITUTIONNAME nvarchar(100);
                    declare @BRANCHNAME nvarchar(100);

                    select 
                        @INSTITUTIONNAME = FINANCIALINSTITUTION,
                        @BRANCHNAME = BRANCHNAME 
                    from dbo.FINANCIALINSTITUTION
                    where ID = @ID

                    if len(@BRANCHNAME) = 0 
                        return @INSTITUTIONNAME
                    else
                        return @INSTITUTIONNAME + ': ' + @BRANCHNAME

                return ''
            end