Function problem

[nikos]

Hello list.

 

Can somebody tells what's wrong with this fuction?

 

DELIMITER $$

 

DROP FUNCTION IF EXISTS `qbit`.`myprice_xondr`$$

 

CREATE FUNCTION `qbit`.`myprice_xondr`(x float(7,2)) RETURNS float(7,2)

BEGIN

CASE x 

WHEN x<50 THEN ceiling(x+x*0.25)

when x>=50 AND x<100 then ceiling(x+x*0.20)

when x>=100 AND x<150 then ceiling(x+x*0.15)

when (x>=150 AND x<200) then (ceiling(x+x*0.10)) 

when (x>=200) then (ceiling(x+x*0.09)) 

end case;

END$$

 

DELIMITER ;

 

Thanx

Nikos