> Can somebody tells what's wrong with this fuction? I guess that depends on what it should do, wouldn't it?
Martijn Tonies Database Workbench - development tool for MySQL, and more! Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com > > > 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 > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]