drop function if exists iffunction
//
create function iffunction(p_comp VARCHAR(10),p_divi VARCHAR(10)) returns VARCHAR(10)
begin

   declare l_value VARCHAR(30);

   if p_comp = 'ACME' then

      if p_divi = 'SALES' then 
	 set l_value := 'You entered ACME Sales';
      elseif p_divi = 'HR' then
      	 set l_value := 'You entered ACME HR';
      elseif p_divi = 'IT 'then 
  	 set l_value := 'You entered ACME IT';
      end if;
   
   elseif p_comp = 'CORP' then
   
      if p_divi = 'SALES' then 
         set l_value := 'You entered CORP Sales';      
      elseif p_divi = 'HR' then
         set l_value := 'You entered CORP HR';            
      elseif p_divi = 'IT' then 
         set l_value := 'You entered CORP IT';        
      end if;
   
   end if;

   return l_value;

end
//