UFN_EDUCATIONALCOLLEGECODE_GETID_FROMNAME

create function dbo.UFN_EDUCATIONALCOLLEGECODE_GETID_FROMNAME(
@Description nvarchar(100),
@IsAffiliated bit = 0,
@AcademicCatalogOn bit = 0
)
returns uniqueidentifier
with execute as caller
as begin
    declare @RETURNVALUE uniqueidentifier;

  if @IsAffiliated = 1 and @AcademicCatalogOn = 1
  begin
      select top 1 @RETURNVALUE = ID
      from
      dbo.ACADEMICCATALOGCOLLEGE AC
      where
      AC.NAME = @Description;
  end
  else
  begin
      select top 1 @RETURNVALUE = ID
      FROM 
      dbo.EDUCATIONALCOLLEGECODE EC
      where
      EC.DESCRIPTION = @Description;
  end

    return @RETURNVALUE;
end