UFN_FINANCIALINSTITUTION_BUILDADDRESS

            CREATE function dbo.UFN_FINANCIALINSTITUTION_BUILDADDRESS
            (
                @INSTITUTIONID uniqueidentifier    
            )
            returns nvarchar(250) 
            with execute as caller
            as begin

                declare @ADDRESSBLOCK nvarchar(150)
                declare @CITY nvarchar(50)
                declare @STATEID uniqueidentifier
                declare @COUNTRYID uniqueidentifier
                declare @POSTCODE nvarchar(12)

                declare @RUNFUNCTION bit

                --Need a GUID to pass to UFN_BUILDFULLADDRESS                

                declare @IDGUID uniqueidentifier 
                set @IDGUID='4B0343D4-9625-4300-A22A-575F25DDAA19'

                select
                    @ADDRESSBLOCK = ADDRESSBLOCK,
                    @CITY = CITY,
                    @STATEID = STATEID,
                    @COUNTRYID = COUNTRYID,
                    @POSTCODE = POSTCODE
                from dbo.FINANCIALINSTITUTION
                where ID = @INSTITUTIONID

                set @RUNFUNCTION = 0

                if @COUNTRYID is null 
                    return ''

                return dbo.UFN_BUILDFULLADDRESS(@IDGUID, @ADDRESSBLOCK, @CITY, @STATEID, @POSTCODE, @COUNTRYID)    

            end