UFN_CURRENCYSET_GETBASECURRENCYDESCRIPTION

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

                              select
                                    @DESCRIPTION =  CURRENCY.NAME + ' (' + ISO4217 + ') - ' + CURRENCYSET.NAME
                              from 
                                    dbo.CURRENCYSET
                                    inner join dbo.CURRENCY on CURRENCYSET.BASECURRENCYID = CURRENCY.ID
                              where 
                                    CURRENCYSET.ID = @ID;

                              return @DESCRIPTION;
                        end