UFN_RESEARCHGROUP_FORMATTEDNAME

            create function dbo.UFN_RESEARCHGROUP_FORMATTEDNAME(@ID uniqueidentifier)
                returns nvarchar(250)
                as BEGIN
          declare @NAME nvarchar(250)

          select 
            @NAME = KEYNAME 
                    +
                      CASE FIRSTNAME WHEN '' THEN 
                        CASE MIDDLENAME WHEN '' THEN '' ELSE ', ' + LEFT(MIDDLENAME,1) + '.' END
                      ELSE 
                        ', ' + FIRSTNAME + CASE MIDDLENAME WHEN '' THEN '' ELSE ' ' + LEFT(MIDDLENAME,1) + '.' END
                      END
          from CONSTITUENT
          where ID = @ID

          RETURN @NAME
        END