UFN_WEALTHSOURCE_GETNAME

            create function dbo.UFN_WEALTHSOURCE_GETNAME(@ID uniqueidentifier)
            returns nvarchar(100)
            with execute as caller
            as begin
                declare @SOURCENAME nvarchar(100);

                select 
                    @SOURCENAME = SOURCE 
                from 
                    dbo.WEALTHSOURCE
                where 
                    ID = @ID;

                return @SOURCENAME;
            end