UFN_TRANSLATIONFUNCTION_ACADEMICCATALOGDEPARTMENT_USERIDFORDUPESCHOOL

create function dbo.UFN_TRANSLATIONFUNCTION_ACADEMICCATALOGDEPARTMENT_USERIDFORDUPESCHOOL(@ID uniqueidentifier) 
    returns nvarchar(155) 
as
begin
    declare @s nvarchar(155);


    select
        @s = case @ID
                when '00000000-0000-0000-0000-000000000000' then 'All departments' 
                when '00000000-0000-0000-0000-000000000001' then 'No departments' 
                else dbo.UFN_ACADEMICCATALOGDEPARTMENT_GETUSERIDFORDUPESCHOOL(@ID) 
             end

    return @s;
end