can anyone help me to solve the error in this SQL query?

Question

I am trying to create a SQL function which will take 2 parameters and convert to requested case format.My query is

DELIMITER $$

CREATE FUNCTION Convertcase(
    sentence VARCHAR(50),req_case VARCHAR(50)
) 
RETURNS VARCHAR(50)
DETERMINISTIC
BEGIN
DECLARE word VARCHAR(50);
IF req_case = 'upper' THEN
    SET word= UPPER(sentence);
ELSEIF req_case = 'lower' THEN
    SET word= LOWER(sentence);
RETURN (word);
END$$
DELIMITER;

convertcase('test sentence','upper')

but I got error

Query : CREATE FUNCTION Convertcase(      sentence varchar(50),req_case varchar(50)  )   RETURNS VARCHAR(50)  DETERMINISTIC  BEGIN  DECL...
Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 13

Answer 1

You need and end if;

drop function if exists convert_case;
DELIMITER $$
CREATE FUNCTION convert_case(sentence VARCHAR(50),req_case VARCHAR(50)) 
RETURNS VARCHAR(50)
BEGIN
DECLARE word VARCHAR(50);
IF req_case = 'upper' THEN
    SET word= UPPER(sentence);
ELSEif req_case = 'lower' THEN
    SET word= LOWER(sentence);
end if; ########
return word;
END$$
DELIMITER ;