UFN_CURRENCY_GETDESCRIPTION

                create function dbo.UFN_CURRENCY_GETDESCRIPTION
                (
                    @ID uniqueidentifier
                ) 
                returns nvarchar(110)
                with execute as caller
                as
                begin
                    declare @DESCRIPTION nvarchar(110);

                    select
                        @DESCRIPTION = NAME + ' (' + ISO4217 + ')'
                    from 
                        dbo.CURRENCY
                    where 
                        ID = @ID;

                    return @DESCRIPTION;
                end