UFN_TRANSLATIONFUNCTION_BILLINGTRANSACTION

                CREATE function dbo.UFN_TRANSLATIONFUNCTION_BILLINGTRANSACTION
                (
                    @ID uniqueidentifier
                )
                returns nvarchar(500) 
                as
                begin
                    declare @s nvarchar(500);

                    select 
                    @s = convert(nvarchar(10), FINANCIALTRANSACTION.[DATE], 101) + ' ' + FINANCIALTRANSACTION.[TYPE] + ': ' + cast(FINANCIALTRANSACTION.[TRANSACTIONAMOUNT] as nvarchar(20)) + ' - ' + ltrim(rtrim(CONSTITUENT.[NAME]))
                    from dbo.FINANCIALTRANSACTION 
                        inner join dbo.CONSTITUENT
                            on FINANCIALTRANSACTION.CONSTITUENTID = CONSTITUENT.ID
                    where FINANCIALTRANSACTION.ID = @ID;

                    return @s;
                end