UFN_TRANSLATIONFUNCTION_CHARITYCLAIMREFERENCENUMBER

                CREATE function dbo.UFN_TRANSLATIONFUNCTION_CHARITYCLAIMREFERENCENUMBER
                (
                    @ID uniqueidentifier
                )
                returns nvarchar(20)
                as
                begin
                    declare @REFERENCENUMBER nvarchar(20);

                    select @REFERENCENUMBER =
                        case when CHARITYCLAIMREFERENCENUMBER.DESCRIPTION = '' then CHARITYCLAIMREFERENCENUMBER.REFERENCENUMBER
                             else CHARITYCLAIMREFERENCENUMBER.REFERENCENUMBER + coalesce(' - ' + min(CHARITYCLAIMREFERENCENUMBER.DESCRIPTION),'')
                        end 
                    from dbo.CHARITYCLAIMREFERENCENUMBER
                    where ID = @ID
                    group by CHARITYCLAIMREFERENCENUMBER.REFERENCENUMBER,CHARITYCLAIMREFERENCENUMBER.DESCRIPTION;

                    return @REFERENCENUMBER;
                end