UFN_CONSTITUENT_SORTNAME

create function dbo.[UFN_CONSTITUENT_SORTNAME] (
  @ID uniqueidentifier
)
returns nvarchar(700)
with execute as caller
as
begin
      declare @result nvarchar(700);
      set @result = '';

    select @result =
        -- Organization and group logic from dbo.UFN_CONSTITUENTDISPLAYNAME, had to copy didn't want to have to reselect

        CASE ISORGANIZATION WHEN 1 THEN
            CASE KEYNAMEPREFIX WHEN '' THEN KEYNAME ELSE KEYNAME + ', ' + KEYNAMEPREFIX END
        ELSE
            CASE ISGROUP WHEN 1 THEN
                CASE DISPLAYNAME WHEN '' THEN KEYNAME ELSE DISPLAYNAME END
            ELSE
            -- Last name first format for individuals.

                dbo.UFN_NAMEFORMAT_08(CONSTITUENT.ID, CONSTITUENT.KEYNAME, CONSTITUENT.FIRSTNAME, CONSTITUENT.MIDDLENAME, null, null, null, null, null, null, null)
            END
        END
    from dbo.CONSTITUENT with(nolock)
    where dbo.CONSTITUENT.ID = @ID;

    return @result;
end