UFN_ADDRESS_GETDESCRIPTION

                create function dbo.UFN_ADDRESS_GETDESCRIPTION(@ID uniqueidentifier) returns nvarchar(100) with execute as caller
                    as
                    begin
                        declare @DESCRIPTION nvarchar(100)

                        select @DESCRIPTION = DESCRIPTION from dbo.ADDRESS where ID = @ID

                        return @DESCRIPTION
                    end