UFN_ADDRESS_GETCONSTITUENTNAME

        create function dbo.UFN_ADDRESS_GETCONSTITUENTNAME(@ID uniqueidentifier)
        returns nvarchar(154)
        as begin
            if @ID is null
                return ''

            return coalesce((select CONSTITUENT.NAME from dbo.ADDRESS inner join dbo.CONSTITUENT on CONSTITUENT.ID = ADDRESS.CONSTITUENTID where ADDRESS.ID=@ID), '')
        end