drop function if exists iffunction
//
create function iffunction(p_inparam VARCHAR(10)) returns VARCHAR(10)
begin

   declare l_value VARCHAR(10);

   if p_inparam = 'A' then

      set l_value := 'This was A';
   
   elseif p_inparam = 'B' then
   
      set l_value := 'This was B';

   else 
   
      set l_value := 'Not A or B';
   
   end if;

   return l_value;

end
//