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