drop function if exists casefunction
//
create function casefunction(p_comp VARCHAR(10)) returns VARCHAR(10)
begin

   declare l_value VARCHAR(30);

   case p_comp 
      when 'ACME' then 
         set l_value := 'It was ACME';
      when 'CORP' then 
         set l_value := 'It was CORP';
      when 'INC' then
         set l_value := 'It was INC';
      when 'ABC' then 
         set l_value := 'It was ABC';
   end case;
   
   return l_value;

end
//